Hi Ron.

>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:

This appears to be an issue with the JET OLE DB Provider; this syntax works fine for other engines I've tested such as SQL Server. Even more interesting is that this error only occurs if you use a connection string; when you specify a DSN instead, it works fine. Weird, huh?

>The problem is that you can not type the “[“ and “]” in the “Select Command” window.

That was originally done because of the way code was generated in the builder: it used "[" and "]" as delimiters for the string, so having these characters inside the string caused a problem. However, the way the code was generated has changed, so you'll be able to enter these characters in a future build.

>all is well as long as your select statement is not to long to fit into the “SelectCmd” property of the cursoradapter object.

That's been changed too. Because VFP limits properties entered in the Property Sheet or through a builder to 255 characters, the CursorAdapter Builder now generates code that sets this property instead.

Doug