Returning primary key into asp local variable!
Any help will be much appreciated. I am trying to insert a record and get the primary key of record at the same time. Is that possible? If so can I return the value into a local asp variable (x). I need the value to perform other inserts in other tables which have a foreign key linked to that primary key.
Eg. str_sql="INSERT INTO mytable VALUES ("'"name"'",.....) RETURNING primaryKey INTO :"& x &".