DATABASE PROBLEM

[Fawaz Ajani]

Hi all! I have a serious problem with DATETIME in SELECT. This is my code:

CRecordset recordset(&database);
CString query;
// m_tabOnglet[0] is a Dialog
m_tabOnglet[0]->GetDlgItemTextW(IDC_DATETIMEPICKER1, datNaiss);
query.Format(L"SELECT numFROM personne WHERE datNais = '%s'", datNaiss);
recordset.Open(CRecordset::snapshot, query);

When I run the debbuger, it show message like this: "incompatible data type in criteria expression"

[Freak30]

Possibly the content of the DateTimePicker is not a string and can't be formated that way. Also it may be a problem that you are missing a space in front of the FROM in the query.

The good thing about pessimism is, that you are always either right or pleasently surprised.

[SujayG]

"

When I run the debbuger, it show message like this:
"incompatible data type in criteria expression

" Exactly in which line does show By the naming convention

m_tabOnglet

looks like a member variable of a tabcontrol.

My Blog

[David Crow]

Using the debugger, what is the value of query?

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles