i've been working with wxdbtable
and i have a problem in setwhereclause
here is my code:
the result is always errortbReservasi->SetWhereClause(wxT("DATE = '04/23/2009'"));
tbReservasi->SetOrderByClause(wxT("TICKET"));
if (!tbReservasi->Query())
n here is the table coldefs :
i use access databaseSetColDefs ( 0,wxT("TICKET"),DB_DATA_TYPE_VARCHAR,ticket, SQL_C_WXCHAR,sizeof(ticket),true,true);
SetColDefs ( 1,wxT("DATE"),DB_DATA_TYPE_DATE,&date, SQL_C_DATE,sizeof(date),false, true); // Primary index
SetColDefs ( 2,wxT("TIMESLOTNO"),DB_DATA_TYPE_INTEGER, ×lotno, SQL_C_UTINYINT,sizeof(timeslotno),false,true);
SetColDefs ( 3,wxT("NIM"),DB_DATA_TYPE_VARCHAR,nim, SQL_C_WXCHAR,sizeof(nim),false,true);
SetColDefs ( 4,wxT("RESERVASISTATUS"), DB_DATA_TYPE_INTEGER,&reservasistatus, SQL_C_UTINYINT,sizeof(reservasistatus),false,true);
thx a lot before