G'Day Nick,
As you correctly suspect, SQL reserved words (like VALUE, DESC, TOP etc) cause havoc when the internal SQL generator makes the INSERT or UPDATE statement for your view. Renaming your field (perhaps to VALUE_ - note the underscore) should do the trick.
Cheers,
Andrew
>Hi
>
>
>I'm having trouble with a view based on a table that includes a field called value.
>
>When I change the contents of value and move off the row I get a syntax error.
>
>Is it not possible to use field names like value in views.
>
>(I can't believe I've not noticed this before)
>
>
>Nick Mason
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.