Marc,

When you go through ODBC you do not 'SELECT ... INTO CURSOR c_cursor', instead you should SQLExec(nHandle, 'SELECT...', 'c_cursor'). Generally speaking, you have to check your ODBC source to make sure that a command is valid. For example, if you work with SQL Server, you cannot use the fox fuction ALLTRIM(...), but you can use LTRIM(RTRIM(...))

Chen

>Hi all !
>Does somebody know if there are some commands in foxpro impossible with ODBC. For example, we heard that SELECT INTO CURSOR will not works properly.
>Is there somewhere a list of forbidden commands for ODBC ?
>
>Thanks you for your time,
>Banania
>
>
>(SL@TC2S.BE)