Methods for cSQLStatement

View method list in alphabetical order.

Name	Type	Description	Defining Class
DFDateToSQLDate	Function	Converts a DataFlex Date data type to a SQL date value that can be used with embedded SQL	cSQLStatement
RemoveComponentIdentifier	Function	Can be used to remove a component identifier from an informational message obtained by calling SQLGetMessage.	cSQLStatement
SQLBindFile	Procedure	Add a file to the list of files bound to the statement result.	cSQLStatement
SQLCall	Procedure	Calls a stored procedure or 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	cSQLStatement
SQLColumnType	Function	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	cSQLStatement
SQLDateToDFDate	Function	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	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	cSQLStatement
SQLFetchRowValues	Function	Fetches a row and returns all columns in an array	cSQLStatement
SQLGetArgument	Function	Get a stored procedure argument.	cSQLStatement
SQLGetData	Function	Get data of a column in chunks (variable length data)	cSQLStatement
SQLGetDataToUChar	Function	Get data of a column to a UChar array, can be used with binary data	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	cSQLStatement
SQLGetStmtAttribute	Function	Gets the value of an embedded SQL Statement attribute	cSQLStatement
SQLNextColumn	Function	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	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. Automatically increments the parameter number.	cSQLStatement
SQLSetParameter	Procedure	Pass a parameter for a parameterized query or stored procedure	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	cSQLStatement
SQLStmtAttribute	Function	[Obsolete] Returns a statement attribute.	cSQLStatement

Inherited Methods from cObject

Name	Type	Description	Defining Class
ChildByIndex	Function	Can be used to iterate the direct children of an object	cObject
ClassSuperClass	Function	Returns the superclass of the passed class	cObject
Create	Function	Creates an object based on the passed Class Id	cObject
CreateNamed	Function	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	cObject
Exit_Application	Procedure	Starts the process of closing an application	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	cObject
ObjectClass	Function	Returns the integer class ID assigned to the class this object is based on	cObject
Request_Destroy_Object	Procedure	Use the Destroy method instead	cObject