Hi, I'm trying to use a POST with Begintrans but it lock the table until I call Commit or RollBack.
This is my code :
ADOQuery.FieldByName('MyField').AsString := 'STRING';
...[do somethings here]
So why this lock the table while execute [do somethings here] ? How could I lock only the record and not the table ? Is there something to do to recover updates ( post ) after a CommitTrans ?
Thanks a lot.