SelStatement Class Reference

#include <Statement.h>

Inheritance diagram for SelStatement:

[legend]Collaboration diagram for SelStatement:

[legend]

Public Member Functions
DbRetVal	execute (int &rowsAffected)
DbRetVal	setParam (int paramNo, void *value)
DbRetVal	setShortParam (int paramNo, short value)
DbRetVal	setIntParam (int paramNo, int value)
DbRetVal	setLongParam (int paramNo, long value)
DbRetVal	setLongLongParam (int paramNo, long long value)
DbRetVal	setByteIntParam (int paramNo, ByteInt value)
DbRetVal	setFloatParam (int paramNo, float value)
DbRetVal	setDoubleParam (int paramNo, double value)
DbRetVal	setStringParam (int paramNo, char *value)
DbRetVal	setDateParam (int paramNo, Date value)
DbRetVal	setTimeParam (int paramNo, Time value)
DbRetVal	setTimeStampParam (int paramNo, TimeStamp value)
DbRetVal	close ()
DbRetVal	resolve ()
	SelStatement ()
	~SelStatement ()
DbRetVal	setBindField (int pos, void *value)
int	noOfProjFields ()
DbRetVal	getProjFldInfo (int projpos, FieldInfo *&fInfo)
DbRetVal	getParamFldInfo (int paramPos, FieldInfo *&info)
void *	fetch ()
void *	fetch (DbRetVal &rv)
void *	fetchAndPrint (bool SQL)
void *	next ()
void *	getFieldValuePtr (int)
DbRetVal	execute (int &rowsAffected)
DbRetVal	setParam (int paramNo, void *value)
DbRetVal	setShortParam (int paramNo, short value)
DbRetVal	setIntParam (int paramNo, int value)
DbRetVal	setLongParam (int paramNo, long value)
DbRetVal	setLongLongParam (int paramNo, long long value)
DbRetVal	setByteIntParam (int paramNo, ByteInt value)
DbRetVal	setFloatParam (int paramNo, float value)
DbRetVal	setDoubleParam (int paramNo, double value)
DbRetVal	setStringParam (int paramNo, char *value)
DbRetVal	setDateParam (int paramNo, Date value)
DbRetVal	setTimeParam (int paramNo, Time value)
DbRetVal	setTimeStampParam (int paramNo, TimeStamp value)
DbRetVal	close ()
DbRetVal	resolve ()
	SelStatement ()
	~SelStatement ()
DbRetVal	setBindField (int pos, void *value)
int	noOfProjFields ()
DbRetVal	getProjFldInfo (int projpos, FieldInfo *&fInfo)
DbRetVal	getParamFldInfo (int paramPos, FieldInfo *&info)
void *	getParamValuePtr (int)
DataType	getFieldType (int)
int	getFieldLength (int)
char *	getFieldName (int)
void *	fetch ()
void *	fetch (DbRetVal &rv)
void *	fetchAndPrint (bool SQL)
void *	next ()
void *	getFieldValuePtr (int)
Data Fields
FieldValue **	bindFields
char **	bindFieldValues
int	totalFields
FieldValue **	bindFields
char **	bindFieldValues

---

Detailed Description

Definition at line 115 of file Statement.h.

---

Constructor & Destructor Documentation

SelStatement::SelStatement

(

)

Definition at line 18 of file SelStatement.cxx.

References bindFields, bindFieldValues, Statement::dbMgr, DmlStatement::params, DmlStatement::paramValues, Statement::parsedData, DmlStatement::table, totalFields, and DmlStatement::totalParams.

{
    parsedData = NULL; 
    dbMgr = NULL; 
    table = NULL;
    params = NULL;
    paramValues = NULL;
    totalParams = 0;
    bindFields = NULL;
    bindFieldValues = NULL;
    totalFields = 0;
}

SelStatement::~SelStatement

(

)

Definition at line 31 of file SelStatement.cxx.

References bindFields, bindFieldValues, DatabaseManager::closeTable(), Statement::dbMgr, DmlStatement::params, DmlStatement::paramValues, Table::setCondition(), DmlStatement::table, totalFields, and DmlStatement::totalParams.

{
    if (table) {
        table->setCondition(NULL);
        if (dbMgr) dbMgr->closeTable(table);
    }
    if (totalParams) {
        free(params);
        params =  NULL;
        free(paramValues);
        paramValues = NULL;
    }
    if (totalFields)
    {
        free(bindFields);
        bindFields =  NULL;
        free(bindFieldValues);
        bindFieldValues = NULL;

    }
}

Here is the call graph for this function:

SelStatement::SelStatement

(

)

SelStatement::~SelStatement

(

)

---

Member Function Documentation

DbRetVal SelStatement::close

(

)

DbRetVal SelStatement::close

(

)

Definition at line 492 of file SelStatement.cxx.

References Table::close(), and DmlStatement::table.

Referenced by SqlStatement::close().

{
    return table->close();
}

Here is the call graph for this function:

Here is the caller graph for this function:

DbRetVal SelStatement::execute

(

int &

rowsAffected

)

[virtual]

Implements DmlStatement.

DbRetVal SelStatement::execute

(

int &

rowsAffected

)

[virtual]

Implements DmlStatement.

Definition at line 65 of file SelStatement.cxx.

References AllDataType::copyVal(), Table::execute(), ConditionValue::length, OK, DmlStatement::params, DmlStatement::paramValues, DmlStatement::table, DmlStatement::totalParams, ConditionValue::type, and ConditionValue::value.

{
    DbRetVal rv = OK;
    //copy param values to binded buffer
    ConditionValue *value;
    for (int i = 0; i < totalParams; i ++)
    {
        value = (ConditionValue*) params[i];
        if (paramValues[i] == NULL) 
        {
            continue;
            //printError(ErrBadCall, "param values not set");
            //return ErrBadCall;
        }
        AllDataType::copyVal(value->value, paramValues[i], value->type, value->length);
    }
    rv = table->execute();
    return rv;
}

Here is the call graph for this function:

void* SelStatement::fetch

(

DbRetVal &

rv

)

void* SelStatement::fetch

(

)

void * SelStatement::fetch

(

DbRetVal &

rv

)

Definition at line 473 of file SelStatement.cxx.

References bindFields, bindFieldValues, AllDataType::copyVal(), ErrBadCall, Table::fetch(), FieldValue::length, printError, DmlStatement::table, totalFields, FieldValue::type, and FieldValue::value.

{
    void *tuple = table->fetch(rv);
    if (NULL == tuple) return NULL;
    //copy values to binded buffer
    FieldValue *value;
    for (int i = 0; i < totalFields; i++)
    {
        value = bindFields[i];
        if (bindFieldValues[i] == NULL) 
        {
            printError(ErrBadCall, "Fields are not binded properly. Should never happen");
            return NULL;
        }
        AllDataType::copyVal(bindFieldValues[i], value->value, value->type, value->length);
    }
    return tuple;
}

Here is the call graph for this function:

void * SelStatement::fetch

(

)

Definition at line 454 of file SelStatement.cxx.

References bindFields, bindFieldValues, AllDataType::copyVal(), ErrBadCall, Table::fetch(), FieldValue::length, printError, DmlStatement::table, totalFields, FieldValue::type, and FieldValue::value.

Referenced by SqlStatement::fetch().

{
    void *tuple = table->fetch();
    if (NULL == tuple) return NULL;
    //copy values to binded buffer
    FieldValue *value;
    for (int i = 0; i < totalFields; i++)
    {
        value = bindFields[i];
        if (bindFieldValues[i] == NULL) 
        {
            printError(ErrBadCall, "Fields are not binded properly. Should never happen");
            return NULL;
        }
        AllDataType::copyVal(bindFieldValues[i], value->value, value->type, value->length);
    }
    return tuple;
}

Here is the call graph for this function:

Here is the caller graph for this function:

void* SelStatement::fetchAndPrint

(

bool

SQL

)

void * SelStatement::fetchAndPrint

(

bool

SQL

)

Definition at line 536 of file SelStatement.cxx.

References bindFields, Table::fetch(), Table::getName(), Table::isFldNull(), FieldValue::length, AllDataType::printVal(), stmt, DmlStatement::table, totalFields, FieldValue::type, typeDate, typeString, typeTime, typeTimeStamp, and FieldValue::value.

Referenced by SqlStatement::fetchAndPrint().

{
    void *tuple = table->fetch();
    if (NULL == tuple) return NULL;
    FieldValue *value;
    bool nullValueSet;
    char stmt[128];
    if (SQL) {
        sprintf(stmt, "INSERT INTO %s VALUES(", table->getName());
        printf("%s", stmt);
    }
    for (int i = 0; i < totalFields; i++)
    {
        value = bindFields[i];
        nullValueSet = table->isFldNull(i+1);
        if (nullValueSet) 
            if (SQL) { 
                if (i==0) 
                    printf("NULL"); 
                else
                    printf(", NULL"); 
            }
            else printf("NULL\t");
        else  {
            if (SQL) {
                switch(value->type)
                {
                    case typeString:
                    case typeDate:
                    case typeTime:
                    case typeTimeStamp:
                    {
                        if (i==0) 
                            printf(" '"); 
                        else
                            printf(", '");
                        break;
                    }
                    default:
                    {
                        if (i!=0) 
                           printf(",");
                    }
                }
            }
            AllDataType::printVal(value->value, value->type, value->length);
            if (SQL) {
                switch(value->type)
                {
                    case typeString:
                    case typeDate:
                    case typeTime:
                    case typeTimeStamp:
                        printf("'");
                }
            } else printf("\t");
        }
    }
    if (SQL) printf(");\n");
    return tuple;
}

Here is the call graph for this function:

Here is the caller graph for this function:

int SelStatement::getFieldLength

(

int

)

Definition at line 530 of file SelStatement.cxx.

References bindFields, and FieldValue::type.

Referenced by SqlStatement::getFieldLength().

{
    FieldValue *v = bindFields[pos];
    return ( (int) v->type );
}

Here is the caller graph for this function:

char * SelStatement::getFieldName

(

int

)

Definition at line 502 of file SelStatement.cxx.

References ErrSysFatal, FieldName::fldName, ParsedData::getFieldNameList(), List::getIterator(), ListIterator::hasElement(), ListIterator::nextElement(), Statement::parsedData, and printError.

Referenced by SqlStatement::getFieldName().

{
    //TODO::if not yet prepared return error
    //TODO::check the upper limit for projpos
    ListIterator iter = parsedData->getFieldNameList().getIterator();
    int position =0;
    while (iter.hasElement())
    {
        if (position == pos) {
              FieldName *name = (FieldName*) iter.nextElement();
              if (NULL == name)
              {
                  printError(ErrSysFatal, "Should never happen. Field Name list has NULL");
                  return (char*) 0;
              }
              return name->fldName;
      }
        position++;
    }
    return (char*) 0;
}

Here is the call graph for this function:

Here is the caller graph for this function:

DataType SelStatement::getFieldType

(

int

)

Definition at line 524 of file SelStatement.cxx.

References bindFields, and FieldValue::type.

Referenced by SqlStatement::getFieldType().

{
    FieldValue *v = bindFields[pos];
    return ( (DataType) v->type );
}

Here is the caller graph for this function:

void* SelStatement::getFieldValuePtr

(

int

)

void * SelStatement::getFieldValuePtr

(

int

)

Definition at line 603 of file SelStatement.cxx.

References bindFields, and FieldValue::value.

Referenced by SqlStatement::getFieldValuePtr().

{
    FieldValue *v = bindFields[pos];
    return ( (void*) v->value );
}

Here is the caller graph for this function:

DbRetVal SelStatement::getParamFldInfo	(	int	paramPos,
		FieldInfo *&	info
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::getParamFldInfo	(	int	paramPos,
		FieldInfo *&	info
	)			[virtual]

Implements DmlStatement.

Definition at line 52 of file SelStatement.cxx.

References ErrBadArg, ErrSysFatal, ConditionValue::length, FieldInfo::length, OK, DmlStatement::params, printError, DmlStatement::totalParams, ConditionValue::type, and FieldInfo::type.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    info->type = cValue->type;
    info->length = cValue->length;
    return OK;
}

void * SelStatement::getParamValuePtr

(

int

)

[virtual]

Implements DmlStatement.

Definition at line 496 of file SelStatement.cxx.

References DmlStatement::params, and ConditionValue::value.

{
    ConditionValue *p = (ConditionValue*) params [pos-1];
    return ( (void*) p->value );
}

DbRetVal SelStatement::getProjFldInfo	(	int	projpos,
		FieldInfo *&	fInfo
	)

DbRetVal SelStatement::getProjFldInfo	(	int	projpos,
		FieldInfo *&	fInfo
	)

Definition at line 614 of file SelStatement.cxx.

References ErrSysFatal, FieldName::fldName, Table::getFieldInfo(), ParsedData::getFieldNameList(), List::getIterator(), ListIterator::hasElement(), ListIterator::nextElement(), OK, Statement::parsedData, printError, and DmlStatement::table.

Referenced by SqlStatement::getProjFldInfo().

{
    //TODO::if not yet prepared return error
    //TODO::check the upper limit for projpos
    ListIterator iter = parsedData->getFieldNameList().getIterator();
    FieldName *name = NULL;
    DbRetVal rv = OK;
    int position =0;
    while (iter.hasElement())
    {
        name = (FieldName*)iter.nextElement();
        if (NULL == name) 
        {
            printError(ErrSysFatal, "Should never happen. Field Name list has NULL");
            return ErrSysFatal;
        }
        if (position == projpos) break;
        position++;
    }

    rv = table->getFieldInfo(name->fldName, fInfo);
}

Here is the call graph for this function:

Here is the caller graph for this function:

void* SelStatement::next

(

)

void * SelStatement::next

(

)

Definition at line 598 of file SelStatement.cxx.

References Table::fetch(), and DmlStatement::table.

Referenced by SqlStatement::next().

{
    return( table->fetch() );
}

Here is the call graph for this function:

Here is the caller graph for this function:

int SelStatement::noOfProjFields

(

)

int SelStatement::noOfProjFields

(

)

Definition at line 609 of file SelStatement.cxx.

References totalFields.

Referenced by SqlStatement::noOfProjFields().

{
    return totalFields;
}

Here is the caller graph for this function:

DbRetVal SelStatement::resolve

(

)

[virtual]

Implements DmlStatement.

DbRetVal SelStatement::resolve

(

)

[virtual]

Implements DmlStatement.

Definition at line 238 of file SelStatement.cxx.

References AllDataType::alloc(), Table::bindFld(), DatabaseManager::closeTable(), Statement::dbMgr, ErrNoConnection, ErrNotExists, ErrNotFound, ErrSyntaxError, ErrSysFatal, FieldName::fldName, ParsedData::getCondition(), Table::getFieldInfo(), ParsedData::getFieldNameList(), List::getIterator(), ParsedData::getTableName(), ListIterator::hasElement(), ParsedData::insertFieldValue(), FieldInfo::length, FieldValue::length, ListIterator::nextElement(), OK, DatabaseManager::openTable(), FieldValue::paramNo, Statement::parsedData, FieldValue::parsedString, printError, ListIterator::reset(), Table::setCondition(), DmlStatement::table, FieldInfo::type, FieldValue::type, and FieldValue::value.

{
    if (dbMgr == NULL) return ErrNoConnection;
    //check whether the table exists
    table = dbMgr->openTable(parsedData->getTableName());
    if (table == NULL) 
    {
        printError(ErrNotExists, "Unable to open the table:Table not exists");
        return ErrNotExists;
    }
    //get the fieldname list and validate field names
    ListIterator iter = parsedData->getFieldNameList().getIterator();
    FieldName *name = NULL;
    FieldInfo *fInfo = new FieldInfo();
    DbRetVal rv = OK;
    while (iter.hasElement())
    {
        name = (FieldName*)iter.nextElement();
        if (NULL == name) 
        {
            dbMgr->closeTable(table);
            table = NULL;
            delete fInfo;
            printError(ErrSysFatal, "Should never happen. Field Name list has NULL");
            return ErrSysFatal;
        }
        if ('*' == name->fldName[0]) 
        {
            iter.reset();
            while (iter.hasElement())
                delete (FieldName *) iter.nextElement();
            rv = resolveStar();
            if (rv != OK)
            { 
                dbMgr->closeTable(table);
                table = NULL;
                delete fInfo; 
                return rv; 
            }
            //as soon as it encounters *, it breaks the loop negleting other field names
            //as they all are deleted during resolveStar method.
            break;
        } else {
            rv = table->getFieldInfo(name->fldName, fInfo);
            if (ErrNotFound == rv)
            {
                dbMgr->closeTable(table);
                table = NULL;
                delete fInfo;
                printError(ErrSyntaxError, "Field %s does not exist in table", 
                                        name->fldName);
                return ErrSyntaxError;
            }
            FieldValue *newVal = new FieldValue();
            newVal->parsedString = NULL;
            newVal->paramNo = 0;
            newVal->type = fInfo->type;
            newVal->length = fInfo->length;
            newVal->value = AllDataType::alloc(fInfo->type, fInfo->length);
            parsedData->insertFieldValue(newVal);
            table->bindFld(name->fldName, newVal->value);
        }
    }
    delete fInfo;

    rv = setBindFieldAndValues();
    if (rv != OK) 
    {
        dbMgr->closeTable(table);
        table = NULL;
        return rv;
    }

    table->setCondition(parsedData->getCondition());

    rv = resolveForCondition();
    if (rv != OK) 
    {
        //TODO::free memory allocated for params
        table->setCondition(NULL);
        dbMgr->closeTable(table);
        table = NULL;
    }
    return rv;
}

Here is the call graph for this function:

DbRetVal SelStatement::setBindField	(	int	pos,
		void *	value
	)

DbRetVal SelStatement::setBindField	(	int	pos,
		void *	value
	)

Definition at line 228 of file SelStatement.cxx.

References bindFieldValues, ErrBadArg, and OK.

Referenced by SqlStatement::bindField().

{
    if (colNo <=0) return ErrBadArg;
    //TODO: check the upper limit
    //if (colNo > table->getFieldNameList().size()) return ErrBadArg;
    if (NULL == value) return ErrBadArg;
    bindFieldValues[colNo -1] = (char*) value; 
    return OK;
}

Here is the caller graph for this function:

DbRetVal SelStatement::setByteIntParam	(	int	paramNo,
		ByteInt	value
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::setByteIntParam	(	int	paramNo,
		ByteInt	value
	)			[virtual]

Implements DmlStatement.

Definition at line 143 of file SelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(ByteInt*)cValue->value = value; 
    return OK;
}

DbRetVal SelStatement::setDateParam	(	int	paramNo,
		Date	value
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::setDateParam	(	int	paramNo,
		Date	value
	)			[virtual]

Implements DmlStatement.

Definition at line 191 of file SelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(Date*)cValue->value = value; 
    return OK;
}

DbRetVal SelStatement::setDoubleParam	(	int	paramNo,
		double	value
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::setDoubleParam	(	int	paramNo,
		double	value
	)			[virtual]

Implements DmlStatement.

Definition at line 167 of file SelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(double*)cValue->value = value; 
    return OK;
}

DbRetVal SelStatement::setFloatParam	(	int	paramNo,
		float	value
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::setFloatParam	(	int	paramNo,
		float	value
	)			[virtual]

Implements DmlStatement.

Definition at line 155 of file SelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(float*)cValue->value = value; 
    return OK;
}

DbRetVal SelStatement::setIntParam	(	int	paramNo,
		int	value
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::setIntParam	(	int	paramNo,
		int	value
	)			[virtual]

Implements DmlStatement.

Definition at line 106 of file SelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(int*)cValue->value = value; 
    return OK;
}

DbRetVal SelStatement::setLongLongParam	(	int	paramNo,
		long long	value
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::setLongLongParam	(	int	paramNo,
		long long	value
	)			[virtual]

Implements DmlStatement.

Definition at line 131 of file SelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(long long*)cValue->value = value; 
    return OK;
}

DbRetVal SelStatement::setLongParam	(	int	paramNo,
		long	value
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::setLongParam	(	int	paramNo,
		long	value
	)			[virtual]

Implements DmlStatement.

Definition at line 118 of file SelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(long*)cValue->value = value; 
    return OK;
}

DbRetVal SelStatement::setParam	(	int	paramNo,
		void *	value
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::setParam	(	int	paramNo,
		void *	value
	)			[virtual]

Implements DmlStatement.

Definition at line 85 of file SelStatement.cxx.

References ErrBadArg, OK, DmlStatement::paramValues, and DmlStatement::totalParams.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    if (NULL == value) return ErrBadArg;
    paramValues[paramNo -1] = (char*) value; 
    return OK;
}

DbRetVal SelStatement::setShortParam	(	int	paramNo,
		short	value
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::setShortParam	(	int	paramNo,
		short	value
	)			[virtual]

Implements DmlStatement.

Definition at line 93 of file SelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "field value is null. Should never happen");
        return ErrSysFatal;
    }
    *(short*)cValue->value = value; 
    return OK;
}

DbRetVal SelStatement::setStringParam	(	int	paramNo,
		char *	value
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::setStringParam	(	int	paramNo,
		char *	value
	)			[virtual]

Implements DmlStatement.

Definition at line 179 of file SelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    strcpy((char*)cValue->value, value);
    return OK;
}

DbRetVal SelStatement::setTimeParam	(	int	paramNo,
		Time	value
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::setTimeParam	(	int	paramNo,
		Time	value
	)			[virtual]

Implements DmlStatement.

Definition at line 203 of file SelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(Time*)cValue->value = value; 
    return OK;
}

DbRetVal SelStatement::setTimeStampParam	(	int	paramNo,
		TimeStamp	value
	)			[virtual]

Implements DmlStatement.

DbRetVal SelStatement::setTimeStampParam	(	int	paramNo,
		TimeStamp	value
	)			[virtual]

Implements DmlStatement.

Definition at line 215 of file SelStatement.cxx.

References ErrBadArg, ErrSysFatal, OK, DmlStatement::params, printError, DmlStatement::totalParams, and ConditionValue::value.

{
    if (paramNo <=0 || paramNo > totalParams) return ErrBadArg;
    ConditionValue *cValue = (ConditionValue*) params [paramNo-1];
    if (NULL == cValue)
    {
        printError(ErrSysFatal, "condition value is null. Should never happen");
        return ErrSysFatal;
    }
    *(TimeStamp*)cValue->value = value;
    return OK;
}

---

Field Documentation

FieldValue** SelStatement::bindFields

Definition at line 125 of file Statement.h.

FieldValue** SelStatement::bindFields

Definition at line 123 of file Statement.h.

Referenced by fetch(), fetchAndPrint(), getFieldLength(), getFieldType(), getFieldValuePtr(), SelStatement(), and ~SelStatement().

char** SelStatement::bindFieldValues

Definition at line 126 of file Statement.h.

char** SelStatement::bindFieldValues

Definition at line 124 of file Statement.h.

Referenced by fetch(), SelStatement(), setBindField(), and ~SelStatement().

int SelStatement::totalFields

Definition at line 125 of file Statement.h.

Referenced by fetch(), fetchAndPrint(), noOfProjFields(), SelStatement(), and ~SelStatement().

---

The documentation for this class was generated from the following files:

• include/Statement.h
• src/sql/Statement.h
• src/sql/SelStatement.cxx

---