I would agree that this is one of the best new features of VFP 8. But I have run into some problems with the builder.

I am using the cursoradapter builder to get access to an Access database. This database contains tables with long file names (TMO Loans) and long field names (Full Name). I am using an ADO connection string to connect to the database using the “Microsoft Jet 4.0 OLE DB Provider”. The problem is when creating the “Select Command” if I use the “Build” button it creates a sql statement like the following:

Select “Tmo Loans”.account from “Tmo Loans”

This generates an error “Microsoft Jet Database Engine: Syntax error in query. Incomplete query clause”. In order for the statement to be valid it must use the “[“ and “]” around the fields and table name:

Select [Tmo loans.account] from [Tmo loans]

This will not generate the error and will create the schema correctly. The problem is that you can not type the “[“ and “]” in the “Select Command” window. To get around this problem you can copy the select command from this window into Note Pad or some other editor and make your changes and paste it back into the “Select Command” window. Once you have done this you can click the “Build” button for the Schema and all is well as long as your select statement is not to long to fit into the “SelectCmd” property of the cursoradapter object.

Though I have figured out the work around. I though I would share my findings…