Hi Jamie,
you get the rowid of the row just inserted, specifically it returns
the rowid of the last row insert from your current connection to the
database.
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Jun 30, 2007, at 7:17 PM, Jamie Lay wrote:
> Hello All,
>
> If I perform an INSERT then call LASTROWID, am I assured
> of getting the rowid of the row I just inserted or can someone
> insert a row between my two calls and thereby give me the
> wrong rowid? Is there a better way of accomplishing this?
>
> Thanks,
>
> Jamie
>
> Software Factory, LLC
> Sales 800-539-1780
> Support 706-632-3763
> Fax 706-632-6498
> www.installfactory.com
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
|