ExternalDatabase Methods

The methods defined in the ExternalDatabase class are summarized in the following table.

Method Description
abortExternalTransaction Rolls back the changes made during the current transaction
beginExternalTransaction Starts a database transaction
canTransact Returns true if the external database supports transactions
close Closes the connection to an external database
commitExternalTransaction Commits a transaction
executeSQL Directly executes an SQL statement
getFileDSN Returns the file data source name
getLastError Returns the last ODBC exception when the isSQLValid method returns false
getMachineDSN Returns the machine data source name
importStoredProcedures For internal use only
isOpen Returns true if the external database is currently open
isSQLValid Checks the syntax of an SQL statement
isUpdatable Returns true if the external database can be updated
loadProcedure Reserved for future use
open Opens a connection to an external database
setFileDSN Programmatically sets the file data source name
setMachineDSN Programmatically sets the machine data source name