I'm not quite sure where to post this message. So, if this seems like the wrong place, please suggest an alternative.

I am getting a very strange error.

I am attempting to use the VFP 9 View Designer to create a view into a Firebird database.

The Firebird database is on my computer, the same computer where I am running the VFP View designer.

I am accessing the Firebird database using Firebird ODBC driver.

I can use the FlameRobin utility to connect to the Firebird database through the ODBC data source without any problems.

In VFP9, I try to create a new view. I select the ODBC data source that I have set up to connect to the Firebird database. The View Designer presents me with a list of tables in the Firebird database. Regardless of which table I select, and click the Add button, I get the same error message:

Connectivity error: [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 21

What is particularly odd about this error is that it is the same error that I got a few months ago when I first started working on this project. Turns out one of the Firebird tables used a UDF call in the definition of its column 21. Once I made sure that that UDF was available, this error went away.

It is almost like this problem is cached somewhere. I tried rebooting the computer, but the problem persists.

Incidentally, if I use the CREATE SQL VIEW command in the command window, I can create a view of the Firebird database without a problem.

Thanks in advance for your help.
Jim