I am using the folowing code
1 dbsetprop transactions to manual
2 read a record from table A
3 then insert a record to table B or table C
4 then update table A that the record has been processed
and where the data was inserted
5 then commit
Between steps 1 and 5 the table A is locked
This prevents other programs from inseritng into table A
Is there any way to prevent the locking.
TIA
Noach