I want to disable user to delete records with specific status.
The problem occures when other user changes status before first user starts
deleting.

First I viewed in my app records with STATUS=1 in Grid and selected one
record for deleting.
Then I opened IBAdmin and changed this records STATUS=2, then Commited.
In my app I run though this code:
if(!DModule->Trans->InTransaction) // uus katsetus
DModule->Trans->StartTransaction();

(dynamic_cast<TIB_BDataset*>(DSource->Dataset))->SelectedBookmarks(StringLis
t);

DSource->Dataset->InvalidateRowNum(DSource->Dataset->RowNum);
int stat=DSource->Dataset->FieldByName("STATUS")->AsInteger;
and stat=1, but it should be 2.

What am I doing wrong here? By default the Trans->AutoCommit=true, but
because here I process all selected records, I wanted to have explicit
transaction, which I later Commit or Rollback.



Riho-Rene Ellermaa
senior programmer
Hansabank