Hi Stephane,
For ODBC driver you can use escape sequention:
WHERE field={d '2004-01-30'}
WHERE field={ts '2004-01-30 11:11:11'}
MartinJ
>Hello,
>
>From VFP8, I execute some SQL requests through ODBC.
>The data sources can be SQL Server, DBF tables (odbc), MySQL, and so on...
>A problem appears when I want to construct requests with dates.
>According to the SQL system, the syntax for dates are different.
>Ex.: ...where date='10-14-2004' works on SQL server but does not work with DBF tables.
>Is there a 'universal' syntax which can work on all SQL systems ?
>Any tips ?
>
>Thanks for your help.
>Regards,
>Steph