MicroStation PowerDraft CONNECT Edition Help

Manually Committing SQL Statements

SQL statements are generated by MicroStation PowerDraft each time you use certain database tools and key-ins. For example, MicroStation PowerDraft generates a SQL INSERT statement when you use the Attach Active Entity tool with Linkage Mode set to New.

By default, MicroStation PowerDraft immediately commits SQL statements to the database software. In an alternate mode, MicroStation PowerDraft commits statements only when your input necessitates the addition of a row to a database table. The process of adding rows requires the database software to lock tables, and commitment is required to release those locks. The alternate mode can be useful when it is desirable to be able to undo uncommitted SQL statements.

Note: You must type COMMIT before exiting MicroStation PowerDraft when the AUTOCOMMIT mode is set to OFF. Otherwise uncommitted transactions will be discarded.