Folks, this one has me stumped...
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.
Can anyone point me in the right direction on this?
Integrity, integrity, integrity!