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