Using FVP8 SP1 I was hoping to get away from having to manually build views, but no luck.

I have a SQL Server table used by a comercial application over which I have no control with several column names that include number signs, e.g.: LIFE#_ORDERS VFP's view designer doesn't seem to be able to cope with these names when explicitly selected. If I pick the column the view designer saves the view just fine and I can browse the view just fine, but I cannot open the view again in the view designer. I get the error message:
SQL: Column 'LIFE' is not found.

I've tried every trick I could think of using square brackets, quotes, double quotes, using "as" to rename it and other tricks I would be embarassed to admit trying in my desperation. Every attempt resulted in some error, either when trying to edit the SQL editor, when opening in the view designer, or when trying to save the view.

For testing I selected only this field in a test view and still got the same error. The SQL statement looks like:
SELECT Syscust.LIFE#_ORDERS FROM dbo.SYSCUST Syscust
along with some DBSetProp calls that seem irrelevant to the problem.

Since I can browse the view just fine, I have to assume the bug is in the view designer.

For now I'll just build the views manually using a tool I got here several years ago to solve another view designer problem, but it sure would be nice to fix the view designer to work right.

...Jim Hansen
Canyon Country Consulting