soapdog at mac.com
Sun Jul 11 15:07:14 CDT 2004
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.
On Jul 11, 2004, at 4:48 PM, hershbp at verizon.net 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
More information about the use-livecode