Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View Update Problem
Message
 
À
25/03/2003 11:55:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00769777
Message ID:
00769780
Vues:
16
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform