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