Thanks everyone - Lee, you were right, there's a PgSQL Get Last Insert Row ID function that's also available in the plug-in. They seem to do the same thing.
Jeff -- Jeffrey Kain [email protected] > On Sep 21, 2017, at 12:54 PM, John DeSoi via 4D_Tech <[email protected]> > wrote: > > That should work without problems. PgSQL Select and PgSQL Execute mostly do > the same things except Execute does not return rows. The "returning" clause > makes it a set returning SQL command so PgSQL Select is the right plugin > command. > > John DeSoi, Ph.D. > > >> On Sep 21, 2017, at 9:37 AM, Jeffrey Kain via 4D_Tech <[email protected]> >> wrote: >> >> 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? ********************************************************************** 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:[email protected] **********************************************************************
