Interbase® Visual SQL component for Delphi 5.

Download Interbase® Visual SQL.

Free version of Visual SQL with complete Pascal source code. Nonvisual component creates visual form for SQL editing, design, and testing. Displays visual SQL form with a simple "open" method (see properties and events below). Uses Interbase Express components and newly added support for FIBPlus contributed by Devrace Software.

Developer comments and suggestions welcome.

Properties and Events:

procedure Open
Use to open the Visual SQL form. First assign the Database property to a TIBDatabase component.

property Database
Assign to a TIBDatabase component. TESSVisualSQL will use the default transaction.

property Dataset
Read only. Points to the internal TIBQuery component used to test SQL statements. Use to get information about the tested result set.

property SystemNames
Same as TIBDatabase SystemsNames. See IB online help for GetTableNames.

event OnApplySQL
Use to get SQL text after a successful retrieval of the Query data. Can be used to extract information with a local TIBSQL, TIBQuery, etc. "Export" button in TESSVisualSQL form will not be enabled unless this event is assigned.

event OnGetTablesNames
If assigned, then you assign the tables in the database the user can select from in a TStringList.

event OnGetRecords
Use in conjunction with DataSet property to get TESSVisualSQL's TIBQuery information so you can set local table information.

event OnHelp
No help is supplied by TESSVisualSQL. Use this method to assign your own help in your software's own style. If unassigned a default no help message will appear.

event OnSaveResults
No export methods are supplied by TESSVisualSQL. Write your own here using Interbase or custom routines. "Save Results" button in TESSVisualSQL form will not be enabled unless this event is assigned.

event OnSQLTest
Test the SQL yourself. Assign Success .= False if the SQL has errors to stop TESSVisualSQL from processing the Query.