UserConnection Class [AX 2012]
The UserConnection class represents an auxiliary connection to the SQL database, based on the same logon properties as the main connection.
| Method | Description | |
|---|---|---|
| cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) |
| createStatement | Creates a Statement object that is used to execute an SQL statement. (Inherited from Connection.) |
| equal | Determines whether the specified object is equal to the current one. (Inherited from Object.) |
| finalize | (Inherited from Connection.) |
| getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
| handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
| new | Initializes a new instance of the Connection class. (Overrides the new Method.) |
| notify | Releases the hold on an object that has called the wait method on this object. (Inherited from Object.) |
| notifyAll | Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.) |
| objectOnServer | Determines whether the object is on a server. (Inherited from Object.) |
| odbcGetInfoInt | Provides an interface to the SQLGetInfo Open Database Connectivity (ODBC) function to retrieve information about the ODBC driver and data source that are associated with a connection. (Inherited from Connection.) |
| odbcGetInfoLong | Provides an interface to the SQLGetInfo ODBC function to retrieve information about the ODBC driver and data source that are associated with a connection. (Inherited from Connection.) |
| odbcGetInfoStr | Provides an interface to the SQLGetInfo ODBC function to retrieve information, in string format, about the ODBC driver and data source that are associated with a connection. (Inherited from Connection.) |
| owner | Returns the instance that owns the object. (Inherited from Object.) |
| setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
| toString | Converts the Connection object to a string. (Inherited from Connection.) |
| ttsabort | Discards changes that are associated with a transaction and rolls the database back to the original state. (Inherited from Connection.) |
| ttsbegin | Begins a transaction. (Inherited from Connection.) |
| ttscommit | Commits the changes that are associated with a transaction to the database. (Inherited from Connection.) |
| ttsLevel | Returns the number for the last call to the ttsbegin method that is used to begin a transaction. (Inherited from Connection.) |
| ttsNotifyAbort | Is called when an exception is thrown. (Inherited from Connection.) |
| ttsNotifyBegin | (Inherited from Connection.) |
| ttsNotifyCommit | Is called when the ttscommit method is called. (Inherited from Connection.) |
| usageCount | Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.) |
| wait | Pauses a process. (Inherited from Object.) |
| xml | Returns an XML string that represents the current object. (Inherited from Object.) |
static void example()
{
UserConnection Con;
Statement Stmt;
Str sql;
ResultSet R;
SqlStatementExecutePermission perm;
Con = new UserConnection();
sql = 'SELECT VALUE FROM SQLSYSTEMVARIABLES';
Stmt = Con.createStatement();
perm = new SqlStatementExecutePermission(sql);
// Check for permission to use the statement.
perm.assert();
R = Stmt.executeQuery(sql);
while ( R.next() )
{
print R.getString(1);
}
}
Community Additions
ADD
Show: