Navigation  without Java Scripts

About SQLdemo

Download.

SQLDEMO is aVisual Prolog application that uses the GRID-tool (a spreadsheet custom control) and the ODBCLIB to connect to various types of databases. (See EXAMPLE\SQLDEMO directory on the CD or in the timelocked version for the source code). The result is the simple database browser/editor.

Note: To use this program you must have ODBC drivers installed and set up to use an ODBC database such as the one supplied with the example.

To open a database using the SQLDEMO example application, the user must choose the menu item 'File-Open Database' and then select one of the ODBC data sources from the list. Then a password input dialog appears. If the selected database uses password protection, the user must type in his name and password else he may leave input fields empty. Then the program will establish the connection with the data source and read the list of available tables. Another dialog asks the user to select one of the tables.

When the table is selected, the database browser window appears. It is possible to open more than one database browser window at a time with different tables from one data source or with tables from different data sources. The user has the opportunity of getting detailed information about table columns by clicking the mouse button in the column title area. He/she may also edit the field contents, add or remove records. The program generates the appropriate SQL statements using database key information if available. A message window displays the SQL statements and the execution results.

Please test this program with non-critical data, as we cannot make guarantees for the security of your data. We cannot guarantee that this example application will run in every environment, on any Windows compatible machine, together with any other application, without producing errors. Any liability for damage of any sort is hereby denied.