Name

Type

Description

SQLUtilColumnExists

Function

Checks if a column/field name exists in an SQL table definition. Returns True if it does.

SqlUtilEnumerateServers

Function

To enumerate the SQL Servers available on the current machine.

SqlUtilEnumerateDatabases

Function

To enumerate the databases for the passed driver.

SqlUtilEnumerateTables

Function

To enumerate tables.

SqlUtilEnumerateTableSpaces

Function

To enumerate table spaces

SqlUtilEnumerateColumns

Function

To enumerate columns/fields

SqlUtilEnumerateIntFiles

Function

To enumerate .int files (intermediate files) for the Data folder.

SqlUtilEnumerateLoggedInUsers

Function

To enumerate logged in users for a particular database.

SqlUtilExecuteResource

Function

Executes the passed memory resource as an SQL (ESQL) script.

SqlUtilExectueQuery

Procedure

Executes the passed string as an ESQL statement (Embedded SQL).

SqlUtilChangeIntFilesToConnectionIDs

Function

To change all .int files in a Data folder to use connection IDs. Changes .int files with explicit User id's and passwords to use Connection ID's

SqlUtilRefreshIntFile

Function

To refresh an .int file after a table has been changed with an external tool.

SqlUtilCreateFileFromMemory

Procedure

Reads a resource that has been embedded by the compiler with the SQLIncludeScriptFile command and writes it to disk.

SqlUtilBackupDatabaseToDisk

Function

To back up an SQL database to disk. Currently only available for MS-SQL Server.

SqlUtilTableIsAttached

Function

Returns True if the Filelist.cfg entry points to SQL and an .int file exists.

SQLUtilDefaultNullValue

Function

To get the SQL default NULL value for a data type

SQLUtilTableIsViewType

Function

Returns True if the passed table handle (Filelist.cfg number) is an SQL View type

SqlUtilGUIDTempTableName

Function

Returns a table name with an underscore followed by a GUID.