We're using the Pluggers PostgreSQL plug-in, and trying to capture the ID of newly inserted rows. It seems like the best way to do this is to put the insert into a Select. The following seems to work, but we've just never done this before and it seems weird... :) Anything to worry about here?
$tStatement:="INSERT INTO invoices (name, amount) VALUES (?,?) returning id" $lStatement:=PgSQL New SQL Statement ($lConnection;$tStatement) PgSQL Set String In SQL ($lStatement;1;$tName) PgSQL Set Real In SQL ($lStatement;2;$rAmount) $rowset:=PgSQL Select ($lConnection;"";$lStatement) $lInvoiceID:=PgSQL Get Longint Column ($rowset;"id") PgSQL Delete Row Set ($rowset) PgSQL Delete SQL Statement ($lStatement) ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************