Hi Mike,
Perhaps Doug assumed (as I did) that you were talking to a SQL Server back end (I missed the ACCOUNTING! database qualifier that indicated Fox).
I can't see a way to use the DESC reserved word in a Fox SQL statement.
Cheers,
Andrew
>Hey Doug,
>
>I have this original code that has an error:
>
>cSQL = [UPDATE ACCOUNTING!ITEMS SET desc = "] + ALLTRIM(cDesc) + ["] + [,] +;
> [ saleprice = ] + STR(nPrice) + [,] +;
> [ WHERE itemid = "] + Alltrim(cItemid) + ["]
>
>the desc field is the reserved word. Are you suggesting that I change it to the following code below?
>
>
>cSQL = [UPDATE ACCOUNTING!ITEMS SET 'desc'= "] + ALLTRIM(cDesc)+ ["] + [,] +;
> [ saleprice = ] + STR(nPrice) + [,] +;
> [ WHERE itemid = "] + Alltrim(cItemid) + ["]
>
>the 2nd set code does not work and produces the same error message..
>Please clarify what you mean...
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.