>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?
>
>Ken.
Watch out for blue fieldnames. Any fieldname that appears as blue in syntax highlighting might cause you trouble eventually.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)