FibPlus Script

FIBPlus Script. Why do you need it? =================================== If you develop database applications you need to create and execute special SQL-scripts. This enables you to simplify deployment and product support modifying and updating metadata in your customer's databases. FIBPlus components executes DDL statements as well as common SQL-commands and you can improve your applications with such feature as built-in metadata updates. However, FIBPlus components do not execute SQL-scripts. You can not execute a few different SQL statements at once with TpFIBQuery or TpFIBDataSet. Both components can operate with single SQL statements only. That's why I had to write my own script component set compatible with FIBPlus. It is compatible with IBX TIBScript, TIBExtract, but unlike the IBX component, it also supports "execute procedure", "create or alter", "describe" (as in IBExpert) etc. Main FIBPlus Script features ============================ Supports all DDL-statements: DECLARE, ALTER, CREATE, etc. Supports database connection/disconnection commands. Supports transaction management commands: START TRANSACTION, COMMIT, etc Supports new Firebird 1.5 and InterBase 7.x SQL. Does not require SET TERM command to separate ALTER TRIGGER and ALTER PROCEDURE statements. Support IBExpert command: DESCRIBE.