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
  
  

Send comments about this topic to Microsoft. В© Microsoft Corporation. All rights reserved.