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 [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
