Methods for cSQLStatement
View method list in hierarchical order.
| Name | Type | Description | Defining Class |
|---|---|---|---|
| ChildByIndex | Function | Can be used to iterate the direct children of an object ChildByIndex is a function that can be used to iterate the direct children of an object. | cObject |
| ClassSuperClass | Function | Returns the superclass of the passed class This returns the superclass of the passed class. | cObject |
| Create | Function | Creates an object based on the passed Class Id The Create function is used to dynamically create objects. | cObject |
| CreateNamed | Function | Creates an object based on the passed Class Id and assigns it a name Name based on a passed name Creates an object based on the passed Class Id and assigns it a name Name based on a passed name. | cObject |
| Destroy | Procedure | Destroys the object that receives the message and any child objects of that object The Destroy message destroys the object that receives the message. | cObject |
| DFDateToSQLDate | Function | Converts a DataFlex Date data type to a SQL date value that can be used with embedded SQL This function will convert a DataFlex date value to a SQL date value that can be used with embedded SQL. | cSQLStatement |
| Exit_Application | Procedure | Starts the process of closing an application The Exit_Application message is used to close the program. | cObject |
| IsClassOfClass | Function | Determines whether the target class is part of the searched class's hierarchy | cObject |
| IsObjectOfClass | Function | Determines whether the passed class is part of the object's class hierarchy This returns True if the passed class is part of the object's class hierarchy. | cObject |
| ObjectClass | Function | Returns the integer class ID assigned to the class this object is based on Returns the integer class ID assigned to the class this object is based on. | cObject |
| RemoveComponentIdentifier | Function | Can be used to remove a component identifier from an informational message obtained by calling SQLGetMessage. | cSQLStatement |
| Request_Destroy_Object | Procedure | Use the Destroy method instead This method is used to destroy an object and all of its children. | cObject |
| SQLBindFile | Procedure | Add a file to the list of files bound to the statement result. | cSQLStatement |
| SQLCall | Procedure | Calls a stored procedure or function Calls a stored procedure or stored function. | cSQLStatement |
| SQLClose | Procedure | Close the statement handle and free the DataFlex statement handle object. | cSQLStatement |
| SQLColAttribute | Function | Returns a column attribute. | cSQLStatement |
| SQLColumnMap | Function | Returns a column number for a name. | cSQLStatement |
| SQLColumnSize | Function | Returns the size (max length) of a column in a result set Returns the size (max length) of a column in a result set. | cSQLStatement |
| SQLColumnType | Function | Returns the native type of a column in a result set Returns the native type of a column in a result set. | cSQLStatement |
| SQLColumnValue | Function | Get a column value. | cSQLStatement |
| SQLColumnVariableDatatype | Function | Determines whether the native type of a column in a result is a variable-length data type Returns 1 if the native type of a column in a result is a variable-length data type. | cSQLStatement |
| SQLDateToDFDate | Function | Converts an SQL DateTime data type to a string in DataFlex Date data type format Converts an SQL DateTime data type to a string in DataFlex Date data type format. | cSQLStatement |
| SQLExecDirect | Procedure | This procedure combines the SQLPrepare and SQLExecute. | cSQLStatement |
| SQLExecute | Procedure | Executes a prepared statement The SQLExecute procedure executes a prepared statement. | cSQLStatement |
| SQLFetch | Function | Fetch the next row of the statement's result set. | cSQLStatement |
| SQLFetchActivatesBuffer | Procedure | Connect or disconnect a file buffer to a statement result set. | cSQLStatement |
| SQLFetchResultsetValues | Function | Fetches all rows of a result Set and Returns the result set as a 2-dimensial array SQLFetchResultsetValues returns a complete result set. | cSQLStatement |
| SQLFetchRowValues | Function | Fetches a row and returns all columns in an array piFetchResult behaves similar to Found. | cSQLStatement |
| SQLGetArgument | Function | Get a stored procedure argument. | cSQLStatement |
| SQLGetData | Function | Get data of a column in chunks (variable length data) In DataFlex 20.0 and higher, SQLGetData cannot be used to get binary data, as binary data can no longer be stored in string variables. | cSQLStatement |
| SQLGetDataToUChar | Function | Get data of a column to a UChar array, can be used with binary data SQLGetDataToUchar can be used to retrieve character data to a UChar array. | cSQLStatement |
| SQLGetMessage | Function | Get informational messages (if any). | cSQLStatement |
| SQLGetNextArgument | Function | Can be used to get return values from a stored procedure in argument order Can be used to get return values from a stored procedure in argument order. | cSQLStatement |
| SQLGetStmtAttribute | Function | Gets the value of an embedded SQL Statement attribute Gets the value of an embedded SQL Statement attribute. | cSQLStatement |
| SQLNextColumn | Function | Can be used to call SQLColumnValue in column order Can be used to call SQLColumnValue in column order. | cSQLStatement |
| SQLNextResultSet | Function | Switch to the next result set of a batch or stored procedure. | cSQLStatement |
| SQLPrepare | Procedure | Prepare a statement that is passed for execution. | cSQLStatement |
| SQLReturnValue | Function | Get a stored function return value. | cSQLStatement |
| SQLSetArgument | Procedure | Sets up a stored procedure argument so it can be passed Sets up an argument to pass to a stored procedure or stored function. | cSQLStatement |
| SQLSetNextArgument | Procedure | Sets up a stored procedure argument so it can be passed and keeps track of the next argument number | cSQLStatement |
| SQLSetNextParameter | Procedure | Pass a parameter for a parameterized query or stored procedure. | cSQLStatement |
| SQLSetParameter | Procedure | Pass a parameter for a parameterized query or stored procedure SQLSetParameter is used to pass parameters for a parameterized query. | cSQLStatement |
| SQLSetProcedureName | Procedure | Setup a stored procedure name so it can be called. | cSQLStatement |
| SQLSetStmtAttribute | Procedure | Sets a statement attribute for an embedded SQL statement Sets an embedded SQL Statement attribute. | cSQLStatement |
| SQLStmtAttribute | Function | [Obsolete] Returns a statement attribute. | cSQLStatement |