Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Update Problem
Message
 
To
25/03/2003 11:55:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00769777
Message ID:
00769780
Views:
17
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
Map
View

Click here to load this message in the networking platform