Is there an environment variable that returns the
primary key of the last inserted row. This is usefull
if you insert a rwo and need the primary key to insert
it into another table as a foreign key.
In MS-SQL that is equivalent to @@identity variable:
insert into organization ('org name', ....)
insert into contact (@@identity, 'contact name'
.....)
Here Identity is the organization's ID that is needed
as a foreign key in contact table.
Cheers.
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com