SQL question

[Paul Kocsis]

Hershel,

If you are INSERTing the record...then you do have all the fields of that
record at the time of INSERT...no?  I would think that you know what the
primary key is at that time...and might want to explore other methods to
accomplish your purpose of wanting to SELECT what you just INSERTed....or am
I missing something significant?

Paul Kocsis
----- Original Message ----- 
From: <hershbp at verizon.net>
To: <use-revolution at lists.runrev.com>
Sent: Sunday, July 11, 2004 2:48 PM
Subject: SQL question


> 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.
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution