Command cannot be issued within a transaction (Error 1593)

You must end all open transactions with END TRANSACTION or ROLLBACK before issuing this command. Visual FoxPro won't allow anything that modifies a database (.dbc) to be part of a transaction. The following commands are illegal within a transaction:

• CLEAR ALL
• CLOSE ALL
• CLOSE DATABASE
• CLOSE TABLES
• COPY INDEXES
• CREATE / DELETE / MODIFY DATABASE
• CREATE / DELETE / MODIFY VIEW
• CREATE / DELETE TRIGGER
• CREATE / DELETE / MODIFY CONNECTION
• APPEND / MODIFY / COPY PROCEDURES

The following commands are not legal for transaction-participating tables:

• ALTER TABLE
• CREATE TABLE (of a table in a database container)
• DELETE TAG
• INDEX ON
• INSERT (non-SQL)
• MODIFY STRUCTURE
• PACK
• TABLEREVERT( )
• Turning off table buffering (by changing the Buffering property from 3 or 5 to 1, 2, or 4 with the CURSORETPROP( ) function).
• Closing a table (by issuing the USE command in the work area of a transaction-participating table)
• ZAP