- SQL::Connection Open Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/Open Method.xml
Connect to a database. (See help for SetConnectionString for details on constructing a connect string.)
- a5SQLConnectionOpen Function
/documentation/pages/Ref/Api/Functions/SQL Helper Functions/a5SQLConnectionOpen Function.xml
Opens a connection to a database. This method supports using dynamic connection syntax.
- SQL::Connection ToOpenTable Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/ToOpenTable Method.xml
Fetch data to an open .DBF table using a SQL query.
- SQL::Query::OpenConnection Method
/documentation/pages/Ref/Api/Namespace/SQL/Query/OpenConnection Method.xml
Generate a native SQL statement using the selected syntax associated with the current or passed connection.
- SQL::ImportStatement::OpenConnection Method
/documentation/pages/Ref/Api/Namespace/SQL/ImportStatement/OpenConnection Method.xml
Generate a native SQL statement using the selected syntax associated with the current or passed connection.
- SQL::Connection ListProperties Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/ListProperties Method.xml
Create a list of all connection property names and values in the format <name><tab><value><crlf>
- SQL::Connection ResultSetFromADORecordSet Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/ResultSetFromADORecordSet Method.xml
Create a SQL::ResultSet object for an ADODB RecordSet.
- SQL::Connection GetTableInfoFromDBF Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/GetTableInfoFromDBF Method.xml
Get the definition of a DBF table from an open table or by name.
- SQL::Connection LastInsertedIdentity Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/LastInsertedIdentity Method.xml
Returns the last inserted identity for a specific table (where possible) after executing an INSERT statement.
- SQL::Connection GenerateLastInsertedIdentityStatement Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/GenerateLastInsertedIdentityStatement Method.xml
Generate a SQL statement to retrieve the identity from the last insert statement (may be specific to the table passed in).