Hi James, thanks for the reply.
>You need to wrap the process into a transaction and then update the counter first and get the PK value and then commit the update. I prefer to do this with a stored procedure that way you only have one call to the database to get the new value.
Looks like one of these methods is the way to go. I have code suggestions for both, which I will be trying-out soon.
Regards,
Alan
Previous
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