General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
You need to set view properties, like:
?dbSetprop("statview.station","FIELD", "KeyField" , .T.)
?dbSetprop("statview.lstsrvdt","FIELD", "Updatable", .T.)
?dbSetprop("statview.lastfaxed","FIELD", "Updatable", .T.)
?dbSetprop("statview","VIEW", "SendUpdates", .T.)
>Hi All,
>
>I am using a local view to access and update data in a table. However, when
>I try to delete or update a record in the view I sometimes receive one of the following messages:
>
>1. Update Conflict
>2. No key columns is specified for the update table "Mydata!Myfile". Use the key field list property of the cursor.
>
>What could have gone wrong with my View? Are there any special setting I need to cater for the view.
>
>Thanks in advance,
>
>Jonathan
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