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.

The best rule of thumb, as stated by my friend the late Tom Piper:

If it turns blue, MODI STRU