Class: cSQLStatement

***************************************************************************** *** Class : cSQLStatement *** *** Purpose: Statement object for embedded sql *** *** *** *** Description: *** *** An object is created for each statement. These will be children *** *** of cSQLConnection objects which manage the create and destruction *** *** of these. *** *****************************************************************************

Class Hierarchy:

ARRAY

cSQLStatement

Class Definition

Properties

IntegerphCLIHandle

IntegerphStmtConnection

IntegerpiBindFile

IntegerpiLastArgument

IntegerpiLastColumn

StringpsDriverID

Functions and Procedures

Construct_object(Integer Image)

StringDFDateToSQLDate(Date dDFDate)

*** *** Function: DFDateToSQLDate *** Purpose : Convert a DataFlex date to a SQL Date. Use dummy zero dates. ***

FreeHandle()

*** *** Procedure: FreeHandle *** Purpose : Free a handle. Since a handle is stored in an *** cSQLStatement object, we destroy the object. ***

HandleError(Integer ihstmt Integer ihdbc String sDrvrId String sOriginMsg)

*** *** Procedure: HandleError *** Puprose : Handle an error that has occured while checking properties. ***

StringRemoveComponentIdentifier(String sDiagMessage)

*** *** Function: RemoveComponentIdentifier *** Purpose : Remove the component identifier from a diagnostic message ***

SQLBindFile(Integer iFileNum)

*** *** Procedure: SQLBindFile *** Purpose : Add a file to the files used to place the statement result in. ***

SQLCall()

*** *** Procedure: SQLCall *** Purpose : Call a stored procedure ***

SQLClose()

*** *** Procedure: SQLClose *** Purpose : Close a statement and free all alllocated resources ***

StringSQLColAttribute(Integer iCol Integer iAttribId)

*** *** Function: SQLColAttribute *** Purpose : Get a column's attribute ***

IntegerSQLColumnMap(String sColname)

*** *** Function: SQLColumnMap *** Purpose : Map a column name to a number, if the name id not found no *** error is generated the returned number will be 0 (zero) in *** that case ***

StringSQLColumnValue(Integer iCol)

*** *** Function: SQLColumnValue *** Purpose : Return the value of a column in a fetched row of a given *** statement. ***

StringSQLDateToDFDate(String sSQLDate)

*** *** Function: SQLDateToDFDate *** Purpose : Convert a SQL date to a DataFlex Date. Use dummy zero dates. *** { Visibility=Private }

SQLExecDirect(String sStatement)

*** *** Procedure: SQLExecDirect *** Purpose : Prepare and execute a statement ***

SQLExecute()

*** *** Procedure: SQLExecute *** Purpose : Execute a prepared statement ***

IntegerSQLFetch()

*** *** Procedure: SQLFetch *** Purpose : Fetch the next row *** Returns : 0 = No more data *** <>0 = Success ***

SQLFetchActivatesBuffer(Integer iFileNum Integer bState)

*** *** Procedure: SQLFetchActivatesBuffer *** Purpose : Setup a file that will be acivated after a succesfull *** fetch on the statement ***

StringSQLGetArgument(Integer iArgnum)

*** *** Function: SQLGetArgument *** Purpose : Get the specified argument from a procedure ***

StringSQLGetData(Integer iCol Integer iLen)

************************************************************************* *** Function: SQLGetData *** *** Purpose : Get data of a column. *** *************************************************************************

StringSQLGetMessage(Integer iMessageNum)

StringSQLGetNextArgument()

*** *** Function: SQLGetNextArgument *** Purpose : Get the next argument ***

SQLIllegalAttribute(String sErrText String sOriginMsg)

*** *** Procedure: SQLIllegalAttribute *** Purpose : Handle an illegal attribute error ***

StringSQLNextColumn()

*** *** Function: SQLNextColumn *** Purpose : Get the next column ***

IntegerSQLNextResultSet()

*** *** Function: SQLNextResultSet *** Purpose : Switch to the next set *** Returns : 0 = No more result sets *** <>0 = Switched to next set ***

SQLPrepare(String sStatement)

*** *** Procedure: SQLPrepare *** Purpose : Prepare a statement for execution ***

StringSQLPrivateColAttribute(Integer iCol Integer iAttribId Integer ihdbc String sDrvrId Integer ihstmt)

IntegerSQLPrivateColumnIsLegal(Integer ihdbc String sDrvrId Integer ihstmt Integer iCol)

*** *** Function: SQLPrivateColumnIsLegal *** Purpose : Check if a column number is legal ***

StringSQLPrivateColumnValue(Integer iCol Integer ihdbc String sDrvrId Integer ihstmt)

StringSQLPrivateStmtAttribute(Integer iAttribId Integer ihdbc String sDrvrId Integer ihstmt)

StringSQLReturnValue()

*** *** Function: SQLReturnValue *** Purpose : Get the reutn value of a stored function ***

SQLSetArgument(Integer iArgnum String sArgument)

*** *** Procedure: SQLSetArgument *** Purpose : Set the next argument ***

SQLSetNextArgument(String sArgument)

*** *** Function: SQLSetNextArgument *** Purpose : Pass the next argument ***

SQLSetProcedureName(String sProcName String sSchemaArg)

*** *** Procedure: SQLSetProcedureName *** Purpsoe : Preapre for calling a stored procedure, pass the procedure name. ***

StringSQLStmtAttribute(Integer iAttribId)

*** *** Function: SQLStmtAttribute *** Purpose : Get a statement attribute ***

StmtError(Integer iErrNum String sErrText String sOriginMsg)

*** *** Procedure: StmtError *** Purpose : Handle general error not related to the properties ***

StoreHandleInfo(Integer iCLIHandle String sDrvrId Integer iParentHandle)

*** *** Procedure: StoreHandleInfo *** Purpose : Store basic information about the statement handle. ***

Instances

References (1):