Lines Matching refs:colDefs
150 colDefs = 0;
219 colDefs = new wxDbColDef[m_numCols]; // Points to the first column definition
365 if (colDefs)
366 delete [] colDefs;
426 switch(colDefs[columnIndex].DbDataType)
430 if (colDefs[columnIndex].Null)
431 colDefs[columnIndex].CbValue = SQL_NULL_DATA;
433 colDefs[columnIndex].CbValue = SQL_NTS;
436 if (colDefs[columnIndex].Null)
437 colDefs[columnIndex].CbValue = SQL_NULL_DATA;
439 colDefs[columnIndex].CbValue = 0;
442 if (colDefs[columnIndex].Null)
443 colDefs[columnIndex].CbValue = SQL_NULL_DATA;
445 colDefs[columnIndex].CbValue = 0;
448 if (colDefs[columnIndex].Null)
449 colDefs[columnIndex].CbValue = SQL_NULL_DATA;
451 colDefs[columnIndex].CbValue = 0;
454 if (colDefs[columnIndex].Null)
455 colDefs[columnIndex].CbValue = SQL_NULL_DATA;
457 if (colDefs[columnIndex].SqlCtype == SQL_C_WXCHAR)
458 colDefs[columnIndex].CbValue = SQL_NTS;
460 colDefs[columnIndex].CbValue = SQL_LEN_DATA_AT_EXEC(colDefs[columnIndex].SzDataObj);
485 if (!colDefs[i].Updateable)
490 if (!colDefs[i].InsertAllowed)
494 switch(colDefs[i].DbDataType)
498 precision = colDefs[i].SzDataObj;
503 precision = colDefs[i].SzDataObj;
528 precision = colDefs[i].SzDataObj;
537 if (SQLBindParameter(hstmtUpdate, colNumber++, SQL_PARAM_INPUT, colDefs[i].SqlCtype,
538 fSqlType, precision, scale, (UCHAR*) colDefs[i].PtrDataObj,
539 precision+1, &colDefs[i].CbValue) != SQL_SUCCESS)
546 if (SQLBindParameter(hstmtInsert, colNumber++, SQL_PARAM_INPUT, colDefs[i].SqlCtype,
547 fSqlType, precision, scale, (UCHAR*) colDefs[i].PtrDataObj,
548 precision+1, &colDefs[i].CbValue) != SQL_SUCCESS)
582 if (SQLBindCol(cursor, (UWORD)(i+1), colDefs[i].SqlCtype, (UCHAR*) colDefs[i].PtrDataObj,
583 colDefs[i].SzDataObj, &colDefs[i].CbValue ) != SQL_SUCCESS)
617 colDefs[i].Null = (colDefs[i].CbValue == SQL_NULL_DATA);
637 colDefs[i].Null = (colDefs[i].CbValue == SQL_NULL_DATA);
694 if (colDefs[i].PtrDataObj == pParmID)
697 retcode = SQLPutData(hstmtUpdate, pParmID, colDefs[i].SzDataObj);
775 if (colDefs[i].KeyField)
777 m_keysize += colDefs[i].SzDataObj;
859 if (! colDefs[i].InsertAllowed)
863 sqlStmt += pDb->SQLColumnName(colDefs[i].ColName);
873 if (! colDefs[i].InsertAllowed)
1093 tStr = colDefs[i].ColName;
1100 pSqlStmt += pDb->SQLColumnName(colDefs[i].ColName);
1218 if (colDefs[i].Updateable)
1225 pSqlStmt += pDb->SQLColumnName(colDefs[i].ColName);
1226 // pSqlStmt += colDefs[i].ColName;
1292 if ((typeOfWhere == DB_WHERE_KEYFIELDS && colDefs[colNumber].KeyField) ||
1296 if (colDefs[colNumber].SqlCtype == SQL_C_TIMESTAMP)
1305 wxString tStr = colDefs[colNumber].ColName;
1312 pWhereClause += pDb->SQLColumnName(colDefs[colNumber].ColName);
1314 if (useLikeComparison && (colDefs[colNumber].SqlCtype == SQL_C_WXCHAR))
1319 switch(colDefs[colNumber].SqlCtype)
1326 colValue.Printf(wxT("'%s'"), GetDb()->EscapeSqlChars((wxChar *)colDefs[colNumber].PtrDataObj).c_str());
1330 colValue.Printf(wxT("%hi"), *((SWORD *) colDefs[colNumber].PtrDataObj));
1333 colValue.Printf(wxT("%hu"), *((UWORD *) colDefs[colNumber].PtrDataObj));
1337 colValue.Printf(wxT("%li"), *((SDWORD *) colDefs[colNumber].PtrDataObj));
1340 colValue.Printf(wxT("%lu"), *((UDWORD *) colDefs[colNumber].PtrDataObj));
1343 colValue.Printf(wxT("%.6f"), *((SFLOAT *) colDefs[colNumber].PtrDataObj));
1346 colValue.Printf(wxT("%.6f"), *((SDOUBLE *) colDefs[colNumber].PtrDataObj));
1351 strMsg.Printf(wxT("wxDbTable::bindParams(): Unknown column type for colDefs %d colName %s"),
1352 colNumber,colDefs[colNumber].ColName);
1424 if (colDefs[i].DerivedCol)
1426 cout << i + 1 << wxT(": ") << colDefs[i].ColName << wxT("; ");
1427 switch(colDefs[i].DbDataType)
1430 cout << pDb->GetTypeInfVarchar().TypeName << wxT("(") << (int)(colDefs[i].SzDataObj / sizeof(wxChar)) << wxT(")");
1452 // Build a CREATE TABLE string from the colDefs structure.
1461 if (colDefs[i].DerivedCol)
1467 sqlStmt += pDb->SQLColumnName(colDefs[i].ColName);
1468 // sqlStmt += colDefs[i].ColName;
1471 switch(colDefs[i].DbDataType)
1493 if (colDefs[i].DbDataType == DB_DATA_TYPE_VARCHAR &&
1495 // colDefs[i].DbDataType == DB_DATA_TYPE_BLOB)
1498 s.Printf(wxT("(%d)"), (int)(colDefs[i].SzDataObj / sizeof(wxChar)));
1509 if (colDefs[i].KeyField)
1520 if (colDefs[i].KeyField)
1564 if (colDefs[i].KeyField)
1568 sqlStmt += pDb->SQLColumnName(colDefs[i].ColName);
1571 colDefs[i].DbDataType == DB_DATA_TYPE_VARCHAR)
1574 s.Printf(wxT("(%d)"), (int)(colDefs[i].SzDataObj / sizeof(wxChar)));
1707 if (wxStrcmp(colDefs[j].ColName,pIndexDefs[i].ColName) == 0)
1716 colDefs[j].DbDataType, (int)(colDefs[j].SzDataObj / sizeof(wxChar)),
1770 if ( wxStrcmp( pIndexDefs[i].ColName, colDefs[j].ColName ) == 0 )
1775 if ( colDefs[j].DbDataType == DB_DATA_TYPE_VARCHAR)
1778 s.Printf(wxT("(%d)"), (int)(colDefs[i].SzDataObj / sizeof(wxChar)));
1924 tempStr += colDefs[colNumber].ColName;
1971 if (colDefs[i].PtrDataObj == pParmID)
1974 retcode = SQLPutData(hstmtInsert, pParmID, colDefs[i].SzDataObj);
2134 switch(colDefs[colNumber].SqlCtype)
2139 return(((UCHAR FAR *) colDefs[colNumber].PtrDataObj)[0] == 0);
2141 return(( *((SWORD *) colDefs[colNumber].PtrDataObj)) == 0);
2143 return(( *((UWORD*) colDefs[colNumber].PtrDataObj)) == 0);
2145 return(( *((SDWORD *) colDefs[colNumber].PtrDataObj)) == 0);
2147 return(( *((UDWORD *) colDefs[colNumber].PtrDataObj)) == 0);
2149 return(( *((SFLOAT *) colDefs[colNumber].PtrDataObj)) == 0);
2151 return((*((SDOUBLE *) colDefs[colNumber].PtrDataObj)) == 0);
2154 pDt = (TIMESTAMP_STRUCT *) colDefs[colNumber].PtrDataObj;
2163 return (colDefs[colNumber].Null);
2219 switch(colDefs[colNumber].SqlCtype)
2226 ((UCHAR FAR *) colDefs[colNumber].PtrDataObj)[0] = 0;
2229 *((SWORD *) colDefs[colNumber].PtrDataObj) = 0;
2232 *((UWORD*) colDefs[colNumber].PtrDataObj) = 0;
2236 *((SDWORD *) colDefs[colNumber].PtrDataObj) = 0;
2239 *((UDWORD *) colDefs[colNumber].PtrDataObj) = 0;
2242 *((SFLOAT *) colDefs[colNumber].PtrDataObj) = 0.0f;
2245 *((SDOUBLE *) colDefs[colNumber].PtrDataObj) = 0.0f;
2249 pDt = (TIMESTAMP_STRUCT *) colDefs[colNumber].PtrDataObj;
2260 pDtd = (DATE_STRUCT *) colDefs[colNumber].PtrDataObj;
2267 pDtt = (TIME_STRUCT *) colDefs[colNumber].PtrDataObj;
2324 if (!colDefs) // May happen if the database connection fails
2329 wxStrncpy(colDefs[index].ColName, fieldName, DB_MAX_COLUMN_NAME_LEN);
2330 colDefs[index].ColName[DB_MAX_COLUMN_NAME_LEN] = 0; // Prevent buffer overrun
2333 fieldName.c_str(),colDefs[index].ColName);
2338 wxStrcpy(colDefs[index].ColName, fieldName);
2340 colDefs[index].DbDataType = dataType;
2341 colDefs[index].PtrDataObj = pData;
2342 colDefs[index].SqlCtype = cType;
2343 colDefs[index].SzDataObj = size; //TODO: glt ??? * sizeof(wxChar) ???
2344 colDefs[index].KeyField = keyField;
2345 colDefs[index].DerivedCol = derivedColumn;
2349 colDefs[index].Updateable = false;
2350 colDefs[index].InsertAllowed = false;
2354 colDefs[index].Updateable = updateable;
2355 colDefs[index].InsertAllowed = insertAllowed;
2358 colDefs[index].Null = false;
2611 colDefs[colNumber].Null = set;
2631 if (!wxStricmp(colName, colDefs[colNumber].ColName))
2637 colDefs[colNumber].Null = set;
2748 switch (colDefs[colNumber].SqlCtype)
2760 val = (wxChar *)(colDefs[colNumber].PtrDataObj);
2764 val = *(long *)(colDefs[colNumber].PtrDataObj);
2768 val = (long int )(*(short *)(colDefs[colNumber].PtrDataObj));
2771 val = (long)(*(unsigned long *)(colDefs[colNumber].PtrDataObj));
2774 val = (long)(*(wxChar *)(colDefs[colNumber].PtrDataObj));
2777 val = (long)(*(wxChar *)(colDefs[colNumber].PtrDataObj));
2780 val = (long)(*(UWORD *)(colDefs[colNumber].PtrDataObj));
2783 val = (DATE_STRUCT *)(colDefs[colNumber].PtrDataObj);
2786 val = (TIME_STRUCT *)(colDefs[colNumber].PtrDataObj);
2789 val = (TIMESTAMP_STRUCT *)(colDefs[colNumber].PtrDataObj);
2792 val = *(double *)(colDefs[colNumber].PtrDataObj);
2811 if ((colDefs[colNumber].SqlCtype == SQL_C_DATE)
2812 || (colDefs[colNumber].SqlCtype == SQL_C_TIME)
2813 || (colDefs[colNumber].SqlCtype == SQL_C_TIMESTAMP))
2820 switch (colDefs[colNumber].SqlCtype)
2832 csstrncpyt((wxChar *)(colDefs[colNumber].PtrDataObj),
2834 colDefs[colNumber].SzDataObj-1); //TODO: glt ??? * sizeof(wxChar) ???
2838 *(long *)(colDefs[colNumber].PtrDataObj) = val;
2842 *(short *)(colDefs[colNumber].PtrDataObj) = (short)val.GetLong();
2845 *(unsigned long *)(colDefs[colNumber].PtrDataObj) = val.GetLong();
2848 *(wxChar *)(colDefs[colNumber].PtrDataObj) = val.GetChar();
2851 *(wxChar *)(colDefs[colNumber].PtrDataObj) = val.GetChar();
2854 *(unsigned short *)(colDefs[colNumber].PtrDataObj) = (unsigned short)val.GetLong();
2860 (DATE_STRUCT *)colDefs[colNumber].PtrDataObj;
2870 (TIME_STRUCT *)colDefs[colNumber].PtrDataObj;
2880 (TIMESTAMP_STRUCT *)colDefs[colNumber].PtrDataObj;
2891 *(double *)(colDefs[colNumber].PtrDataObj) = val;
2911 if (colDefs[i].KeyField)
2913 memcpy(blkptr,colDefs[i].PtrDataObj, colDefs[i].SzDataObj);
2914 blkptr += colDefs[i].SzDataObj;
2936 if (colDefs[i].KeyField)
2939 memcpy(colDefs[i].PtrDataObj, blkptr, colDefs[i].SzDataObj);
2940 blkptr += colDefs[i].SzDataObj;