Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax error
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00331756
Message ID:
00332181
Views:
12
>>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
Map
View

Click here to load this message in the networking platform