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
>
>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
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