Lines Matching refs:colNumber
479 UWORD colNumber;
481 for (i=0, colNumber=1; i < m_numCols; i++)
537 if (SQLBindParameter(hstmtUpdate, colNumber++, SQL_PARAM_INPUT, colDefs[i].SqlCtype,
546 if (SQLBindParameter(hstmtInsert, colNumber++, SQL_PARAM_INPUT, colDefs[i].SqlCtype,
1288 int colNumber;
1289 for (colNumber = 0; colNumber < m_numCols; colNumber++)
1292 if ((typeOfWhere == DB_WHERE_KEYFIELDS && colDefs[colNumber].KeyField) ||
1293 (typeOfWhere == DB_WHERE_MATCHING && (!IsColNull((UWORD)colNumber))))
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));
1352 colNumber,colDefs[colNumber].ColName);
1902 int colNumber = first; // using 'int' to be able to look for wxDB_NO_MORE_COLUN_NUMBERS
1909 while (!abort && (colNumber != wxDB_NO_MORE_COLUMN_NUMBERS))
1915 if (colNumber >= m_numCols || colNumber < 0)
1921 if (colNumber != first)
1924 tempStr += colDefs[colNumber].ColName;
1925 colNumber = va_arg (argptr, int);
2128 bool wxDbTable::IsColNull(UWORD colNumber) const
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);
2215 void wxDbTable::ClearMemberVar(UWORD colNumber, bool setToNull)
2217 wxASSERT(colNumber < m_numCols);
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;
2275 SetColNull(colNumber);
2607 bool wxDbTable::SetColNull(UWORD colNumber, bool set)
2609 if (colNumber < m_numCols)
2611 colDefs[colNumber].Null = set;
2613 ClearMemberVar(colNumber, false); // Must call with false here, or infinite recursion will happen
2615 setCbValueForColumn(colNumber);
2628 int colNumber;
2629 for (colNumber = 0; colNumber < m_numCols; colNumber++)
2631 if (!wxStricmp(colName, colDefs[colNumber].ColName))
2635 if (colNumber < m_numCols)
2637 colDefs[colNumber].Null = set;
2639 ClearMemberVar((UWORD)colNumber,false); // Must call with false here, or infinite recursion will happen
2641 setCbValueForColumn(colNumber);
2743 wxVariant wxDbTable::GetColumn(const int colNumber) const
2746 if ((colNumber < m_numCols) && (!IsColNull((UWORD)colNumber)))
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);
2802 void wxDbTable::SetColumn(const int colNumber, const wxVariant val)
2807 SetColNull((UWORD)colNumber, val.IsNull());
2811 if ((colDefs[colNumber].SqlCtype == SQL_C_DATE)
2812 || (colDefs[colNumber].SqlCtype == SQL_C_TIME)
2813 || (colDefs[colNumber].SqlCtype == SQL_C_TIMESTAMP))
2817 SetColNull((UWORD)colNumber, true);
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;