General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I have a view that has a field "cdesc" which is C (150). If I browse the view, and change the contents of this field, I get a syntax error if I try to leave the record. The only way out is to do a TABLEREVERT().
>
>I can add a record and put something in that field with no problem. It only has a problem if I try to change what's already there.
>
>Anyone seen anything like this?
>
>Thanks,
>
>Michelle
I found it. I went back and looked at the table again, and realized that I didn't have "cdesc". I had "desc". I "always" use "cdesc" since "desc" is a reserved word, but I guess this time I had a brain fart. Must have been confusing FoxPro and all it could think to tell me was "syntax error". :)
Anyway, all fixed now.
Michelle
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only