Jump to content
Mark Williams

FireDAC ArrayDML returning ids

Recommended Posts

I posted a question on this a while back. Trying to establish whether there was a way of retrieving the ids for new rows inserted using ArrayDML. I had tried using "returning id". That didn't work or rather it didn't work as I had hoped. From memory it inserted just one row and returned the id for that row,

 

By chance I came across this post on stackoverflow:

https://stackoverflow.com/questions/66704349/firedac-array-dml-and-returning-clauses

 

I have tried this and get "syntax error at or near {". 

 

I can't find anything on "INTO" in this context. 

 

Also, using PostgreSQL to test.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×