Hai.......
I am using _RecordSetPtr in vc++ using T_TIME table in MS Access 2000
to store the data and diplayed in List control. select a row in list
control and click delete button i want delete record based on
REG_DATE(date/time). I am using the following code
CString sReg_Date;
M_LCtrl_BedInfo.GetItemText(iBedColumn,3);
CString sDelete;
sReg_Date.Trim();
sDelete.Format("delete from T_TIME where REG_DATE = %s
",sReg_Date);
mC_DB->m_AdoDb->BeginTrans();
mC_DB->fn_DeleteData(sDelete);
mC_DB->m_AdoDb->CommitTrans();
it reurns the following error re****t
Syntax error (missing operator) in query expression
Please help me how can delete the record based on Data/time field
Thanks in advance
Mani.
