>when going from local to remote views, at least with a foxpro database on the back end there are some field names that will cause the ODBC driver to throw a confusing syntax error.
>
>i've not seen them documented and I think they should be but so far I have come to realise
>
>VALUE and DESC can not be field names if you hope to go to remote views/odbc.
>
>i had value in a key table and desc as a short for description in a stock table, it's annoying to have to change base tables, views and all related code at a late stage.
>
>anyone know of any others, or even if this is documented somewhere?

You may try DIST for distance, which should give you quite a DISTinct confusion of the kind :).