>>What is the best way to emulate begin atomic in VFP code? Flock() on affected files (shudder)?
>
>I don't know which language "begin atomic" comes from, or what it does. Is that the start of a transaction? If so, look at the BEGIN TRANSACTION command. If not, and no one else knows, you need to explain what this command does.
A pretty good guess, from the look of things. There was nothing on MSKB for BEGIN ATOMIC (maybe SQL Server doesn't support it?) but DB2 (for one) appears to support it (
http://www.db2mag.com/spring00/favero.shtml ).
It looks like a way to execute multiple SQL commands against a backend, and have them all roll back if any one fails. I would sure look at VFP transactions for a first cut.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
