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 This function will convert a DataFlex date value 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 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

Inherited Methods from cObject

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
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
Request_Destroy_Object	Procedure	Use the Destroy method instead This method is used to destroy an object and all of its children.	cObject