What's was missing in my code were the transaction commands for the 'local' data. I had based the structure on a text I found in VFP5 documentation or some other doc. In the online help (section 'Programming for shared access') that comes with vfp6 I found the answer. Here's the structure that did perform well (from the head):
sqlsetprop( handle, 'transaction', 2 )
BEGIN TRANSACTION
ok=.f.
do case
case tableupdate(blabla)
case tableupdate(blabla)
case tableupdate(blabla)
otherwise
ok=.t.
endcase
if ok and sqlcommit(handle)
END TRANSACTION
else
sqlrollback(handle)
ROLLBACK
endif
Note the capitalized commands. It's a pity that this requirement isn't stated more clearly in the documentation, e.g. where the sqlsetprop, sqlrollback and sqlcommit are explained.
Groet,
Peter
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.