- 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 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.)
- SQL::Query::OpenConnection Function
/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 Function
/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 ToOpenTable Method
/documentation/pages/Ref/Api/Namespace/SQL/Connection/ToOpenTable Method.xml
Fetch data to an open .DBF table using a SQL query.
- 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>
- Creating Dynamic Connection Strings
/documentation/pages/Guides/Databases/Connecting/Dynamic Connection Strings.xml
A dynamic connection string is a connection string that is resolved at the time the database connection is opened, rather than at the time the connection string is defined. This is useful in SaaS applications where client data is stored in different systems of record located on different servers.
- 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.