Thanks Martin, but with this escape sequention, SQLEXEC() returns -1.
Any idea ?
Thanks.
Steph
>Hi Stephane,
>
>For ODBC driver you can use escape sequention:
>
> * {d 'YYYY-MM-DD'}
> * {ts 'YYYY-MM-DD hh:mm:ss'}
>
> 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