>Re insert command, just looked up begin transaction command and saw insert command in the list. I
>assumed that meant the Foxpro insert command and was not sure about instert into (sql) command not
>begin allowed in a begin/end transaction consturct.

Yes, that's the xBase INSERT command, which rewrites the entire table after the point where you're doing the insert. INSERT - SQL is fine, but as I mentioned above, you don't want to do the INSERT/REPLACEs inside the transaction.