Command cannot be issued within a transaction (Error 1593)

  • Article

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