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