Hi Everyone,

What is the best or most appropriate way to control record or file locking when using SQL Pass Through on a remote view, to insert transactions into a MS SQL database from my application. There is a table in SQL that I need to push recrods into, but am not sure how I should control the locking requirements to ensure I have the right transaction numbers in a number
field. I might be adding 100 records, each needs the next transaction number, but how do I know someone else isn't doing the same from the main application if I can't lock the file termporarily?


I am thinking something like normal scripting - based on teh keycolum, but not sure if the content or syntax is right:

begin transaction
update mySQLTable
set lockkeycolumn = keycolumn
where custno = mycustno
.....
*-- do rollback or commit

TIA

Ric