A5_BatchPassiveLinkCreate()

V8

Copies data from multiple tables in a back-end database and creates multiple standard or passive-link tables in an Alpha Five database.

A5_ConnectionString()

V7

Displays the standard Windows Data Link Properties dialog box.

A5_CreateLayoutFromDataSource()

V8

A5_CreatePassiveLinkTable()

V7

Creates a passive-link table.

A5_ExcelConnString()

V7

Returns a connection string for a named Excel file.

A5_ImportTablesDialog()

V7

Displays the Import Tables from Remote Database dialog, which allow you to import tables from remote databases or other data sources for which ODBC drivers are available.

A5_PassiveLinkTableDefine()

V7

Creates a passive-link table.

A5_RefreshPassiveLinkTable()

V7

Refreshes the contents of a passive-link table.

A5_RefreshPassiveLinkTableDialog()

V8

Displays a dialog that allows you to choose whether to refresh the currently selected passive-link table or selected passive-link tables.

A5_SQLResultSetPreview()

V8

Displays up to 100 rows of data stored in a SQL::ResultSet object.

A5_SQL_BatchImportTables()

V8

Copies data from multiple tables in a back-end database and creates multiple .DBF tables in an Alpha Five database.

A5_SQL_ImportDataSource()

V8

Imports the data specified by a Data Source name to an Alpha Five table.

A5_SQL_QuerySaveAs()

V8

SQL_ConnectString()

V7

Invokes an API specific dialog to create a connect string.

SQL_ConnectionStringDialog()

V7

Displays the Create SQL Connection String dialog, which returns a connection string suitable for use with a back-end database.

SQL_DatabaseExportDialog()

V8

Displays the Export Database Tables to SQL dialog. This dialog allows you to select any number of local .DBF tables and export them to a SQL back-end database.

SQL_Date()

V7

Generates a character string with the format: {YYYY-MM-DD}.

SQL_Query_Builder()

V8

Displays the SQL Genie to help you define a SQL SELECT statement.

SQL_QueryImport()

V8

Imports a table from a back-end SQL database into an Alpha Five .DBF table.

SQL_ResultSet_Preview()

V8

Displays up to 100 rows from a SQL::ResultSet.

SQL_TableExport()

V8

Copies a local .DBF table to a back-end database.

SQL_TableImport()

V8

Copies a back-end database table a local .DBF table.

SQL_TableImportDialog()

V8

Displays the Table Import dialog, which allows you to import a table from a SQL back-end database to an Alpha Five .DBF table.

SQL_TableInfoOfDBF()

V8

Creates a SQL::TableInfo object from a local .DBF table.

SQL_TableInfoToOpenTable()

V8

Creates a local table from a SQL::TableInfo object.