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
>
>Michelle,
>
>Check the RI rules for the table. This field might be used within a relation. And if the rule is set to restrict...
>
>José
There's no RI. It's a really simple program, and I wrote the whole thing, so I know there's nothng hidden. :)
It was just me being a dumbass and using a reserved word as a field name.
Thanks,
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