>>Per #2 or #3.1 in Message #
989852>>
>Which one are you interested in in you particular case?
In my particular case that's irrelevant because I do not really have a "filter" condition so it doesn't matter to me if "in theory" it is doublechecked.
DELETE FROM Resource WHERE TaskId IN (SELECT Id FROM Task WHERE Task.MainId=12345)
But if by "my case" you mean how I try to use VFP, then probably 3.1 would be my default. But I would lo-o-o-ve to have a SET command for it.
BTW, How's that for a level #4, "Serializable transactions"?
"DBLOCK()" is applied before any UPDATE or DELETE command. This is *very* slow but ensures that the scope is guarantied for the duration of the command.