General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Ken,
>
>Ok, I gotta you... Well the only thing I can think of is VFP views by default will not set the primary key field as updatable. Are you sure the key is checked as updatable in the view designer? I know you said it use to work but that is the only thing I can think of. You could check by opening the view in the IDE and type the following:
>
>? CURSORGETPROP("KeyFieldList")
>? CURSORGETPROP("UpdatableFieldList")
>? CURSORGETPROP("UpdateNameList")
>
>Make sure the field is in each of these lists.
>
Checked each one and yes, the field is there.
Seeing as I am completely stumped I put in a hack: I now set the default value of the table to the value of the field in the view. It means that I can not directly add records to the table if the view does not exist (and would insert a wrong value if it did) but since I only update the table from the view I should be ok (he says whil waiting for that call from the customer...)
Thanks for your idea,
ken
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