Hi Robert
>To reproduce the error:
>
>1.Create a SQL table with a field that has a space in the fieldname (e.g. equipment.[easy model])
>2.In VFP, create a project, Use project manager to create database container.
>3.Create remote view, select all fields of the table.
>4.Save the view.
>5.Go back and modify the view. You'll get an error messagebox that says "Syntax Error".
>
This is not a bug, it is by design (VFP does not, and never has, provided support for spaces in field names)
Fro a remote view you need to use the field name mapping properties but these are not accessible using the designer, only in code. See the UpdateName property in the help for DBGetProp() for details
----
Regards
Andy Kramek