Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update a table in a database with a view
Message
De
05/06/2007 03:51:43
 
 
À
05/06/2007 03:44:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01230467
Message ID:
01230468
Vues:
27
>Hello,
>
>I have a table in a database from which I make a view:
>
>CREATE SQL VIEW view5 AS SELECT uniekid, name1 FROM table1
>
>I make the field in the view updatable:
>
>=DBSETPROP('view5.uniekid', 'Field', 'KeyField', .T.)
>=DBSETPROP('view5.uniekid', 'Field', 'UpDatable', .F.)
>
>=DBSETPROP('view5.name1', 'Field', 'UpDatable', .T.)
>
>I change the inside of the field name1 in the view and then close the view,
>but the inside value of field name1 is not changed...???
>
>Can anybody help me out with this one? What am I doing wrong?
>
>Thanks in advance
>Ron

Maybe this
** Activate the update on view level
=dbsetprop('view5', 'VIEW', 'SendUpdates', .t.)
Gregory
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform