Hi, Bill-
>I'm attempting to build an updateable view through code. For a particular view, there's the CREATE SQL VIEW statement, followed by a number of DBSETPROP statements. These DBSETPROP statements set the Updatable fields (and non-updatable fields) , the Parameters, KeyField, WhereType, Tables, UpdateType and SendUpdate settings for the view.
>
>Whenever I browse, change an updateable value, TableUpdate() and close the cursor, I get a message stating that no Key columns are specified for the update table, use the KeyFieldList property of the cursor. It's error # 1492.
>
>CursorGetProp([KeyFieldList]) returns the correct value.
>
>I have seen this clear up either by opening the view and resetting the key, followed by running my code settings. But not always<s>. I've tried clearing the KeyField/resetting the Keyfield in code, to no avail.
This is probably a dumb question, but how are you assigning the key field? This is a WAG, but maybe there is something in the value of the key field?
Otherwise, can you describe how to reproduce the behavior reliably?
Previous
Next
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