I can use transaction with holdlock rowlock, ex:

sqlexec(mycon,"BEGIN TRANSACTION")
sqlexec(mycon,"SELECT field1 FROM mytable WITH (HOLDLOCK ROWLOCK) WHERE field2 = ?field2value")
..
...
...

...
sqlexec(mycon,"COMMIT TRANSACTION")