I am using vb6 with ado
I was used to use addnew with a recordset
but so I will use somthing like
"insert into dbo_invoice (invoice_id, invoice_date) select max(invoice_id)+1 as new_id, getdate() from dbo_invoice"
what will gurantee that using
rs.open "SELECT @@IDENTITY AS 'Identity'"
will return the Id created by the application current user and not by the some other user??
Offcourse I need for the application to know which one it created in order to open the form with the new id just created!