Hi all,

I have a SQL query problem...

Let's have a table tblPeople with two columns. First one with name fldName of type VT_BSTRT, second one with name fldBirth of type VT_DATE.

User can enter a date in EditBox. So entered date is in the CString variable with name StrVar.

NOW THE QUESTION: How to create an SQL query to get all people, which birthday is greater then entered date?

THIS DOESN'T WORK: I try "SELECT * FROM tblPeople WHERE fldBirth > " + StrVar ... and it doesn't work. Something like parametr mischmasch in DaoException...

The example code will be helpfull.

Thanks...

PetrP.