Mark Williams 14 Posted February 4 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
Mark Williams 14 Posted February 5 Should have mentioned @J. Robroeks in the original post as J posted the solution referred to on SA. Share this post Link to post