Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement