It's strange,

I use this for MySQL, MS Access, Ms SQL and Oracle.

What error is in array after calling AERRORS()? (description)
And what is SQL command?

MartinJ


>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