Hershel,
since you're doing the INSERTS you have access to the inserted data, can't your refine your SELECT query so that you SELECT WHERE and put all the inserted data as refinements, this way you'll retrieve the correct record. Thats what I use here.
Cheers andre
On Jul 11, 2004, at 4:48 PM, [EMAIL PROTECTED] wrote:
HI ,
How do I "INSERT" A SQL statement and return some of the record or field info immediately ?
I'll try to elaborate. A database app. running many clients, I create a new record and want to get the primary key of that newly created record. If I'll do an "INSERT" and then go the last record via "SELECT" then between the INSERT and the SELECT somebody else from a different location can insert a new record then when I do the select to get the last as mentioned above I'll get the wrong pk. How do I overcome that ?
Thanks , Hershel.
-- Andre Alves Garzia 2004 BRAZIL http://studio.soapdog.org
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
