Methods for cSQLStatement

View method list in alphabetical order

NameTypeDescription
DFDateToSQLDateFunctionConverts a DataFlex Date data type to a SQL date value that can be used with embedded SQL
RemoveComponentIdentifierFunctionCan be used to remove a component identifier from an informational message obtained by calling SQLGetMessage.
SQLBindFileProcedureAdd a file to the list of files bound to the statement result.
SQLCallProcedureCalls a stored procedure or function
SQLCloseProcedureClose the statement handle and free the DataFlex statement handle object.
SQLColAttributeFunctionReturns a column attribute.
SQLColumnMapFunctionReturns a column number for a name.
SQLColumnSizeFunctionReturns the size (max length) of a column in a result set
SQLColumnTypeFunctionReturns the native type of a column in a result set
SQLColumnValueFunctionGet a column value.
SQLColumnVariableDatatypeFunctionDetermines whether the native type of a column in a result is a variable-length data type
SQLDateToDFDateFunctionConverts an SQL DateTime data type to a string in DataFlex Date data type format
SQLExecDirectProcedureThis procedure combines the SQLPrepare and SQLExecute.
SQLExecuteProcedureExecutes a prepared statement
SQLFetchFunctionFetch the next row of the statement's result set.
SQLFetchActivatesBufferProcedureConnect or disconnect a file buffer to a statement result set.
SQLFetchResultsetValuesFunctionFetches all rows of a result Set and Returns the result set as a 2-dimensial array
SQLFetchRowValuesFunctionFetches a row and returns all columns in an array
SQLGetArgumentFunctionGet a stored procedure argument.
SQLGetDataFunctionGet data of a column in chunks (variable length data)
SQLGetDataToUCharFunctionGet data of a column to a UChar array, can be used with binary data
SQLGetMessageFunctionGet informational messages (if any).
SQLGetNextArgumentFunctionCan be used to get return values from a stored procedure in argument order
SQLGetStmtAttributeFunctionGets the value of an embedded SQL Statement attribute
SQLNextColumnFunctionCan be used to call SQLColumnValue in column order
SQLNextResultSetFunctionSwitch to the next result set of a batch or stored procedure.
SQLPrepareProcedurePrepare a statement that is passed for execution.
SQLReturnValueFunctionGet a stored function return value.
SQLSetArgumentProcedureSets up a stored procedure argument so it can be passed
SQLSetNextArgumentProcedureSets up a stored procedure argument so it can be passed and keeps track of the next argument number
SQLSetNextParameterProcedurePass a parameter for a parameterized query or stored procedure. Automatically increments the parameter number.
SQLSetParameterProcedurePass a parameter for a parameterized query or stored procedure
SQLSetProcedureNameProcedureSetup a stored procedure name so it can be called.
SQLSetStmtAttributeProcedureSets a statement attribute for an embedded SQL statement
SQLStmtAttributeFunction[Obsolete] Returns a statement attribute.

Inherited Methods from cObject

ChildByIndexFunctionCan be used to iterate the direct children of an object
ClassSuperClassFunctionReturns the superclass of the passed class
CreateFunctionCreates an object based on the passed Class Id
CreateNamedFunctionCreates an object based on the passed Class Id and assigns it a name Name based on a passed name
DestroyProcedureDestroys the object that receives the message and any child objects of that object
Exit_ApplicationProcedureStarts the process of closing an application
IsClassOfClassFunctionDetermines whether the target class is part of the searched class's hierarchy
IsObjectOfClassFunctionDetermines whether the passed class is part of the object's class hierarchy
ObjectClassFunctionReturns the integer class ID assigned to the class this object is based on
Request_Destroy_ObjectProcedureUse the Destroy method instead [Obsolete]