Good point Doug
I'd tend to use [] delimiters rather than quotes though. I'd also rename the field in the SQL statement (using the AS clause) so the problem doesn't arise in the fox portion of the code.
Cheers,
Andrew
>>You've used a reserved word - DESC - in the SQL statement. Rename that field and things should work better.
>
>An alternative is to put quotes around the field name (in case he doesn't own the database and can't rename the field or doesn't want to rename it).
>
>Doug
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.
