General information
Category:
Coding, syntax & commands
thanks for answering back Yuri. What if another user inserts info right after me, will I get the wrong ID? Are there other alternatives to capturing primary key inserted into tables through forms?
thanks
Nick Patel
>Why not just:
>?table_name.lnID_field
>
>>I am using a procedure that autoincrements (like newID) a table. In this procedure the last line has "Returns lnID". When I issue an insert into table, is there a way to capture this Return variable which gives me the new id number for table? I am issuing "insert into" from form but the procedure is run as default value in table.
>>
>>thanks
>>Nick Patel
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only