Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP 3.0 updateable view problem
Message
De
15/11/1996 04:50:11
Andrzej Majlich
Vulcan sp. z o. o.
Wroclaw, Pologne
 
 
À
15/11/1996 02:17:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00012219
Message ID:
00012325
Vues:
35
>did you configure it to send updates on key fields as well..

Yes. Without this, updates to "old" records wouldn't happen I suppose.
I tried to extract problem to a short programm. Here's a setup code of it:

PRIVATE err, tustat

CREATE DATABASE try

CREATE TABLE items (Name C(20), id c(10))
INDEX ON id TAG id
=CURSORSETPROP('buffering',5,'items')

CREATE SQL VIEW v_items AS SELECT * FROM items
=DBSETPROP('v_items', 'View', 'Tables', 'items')
=DBSETPROP('v_items', 'View', 'WhereType', 1)
=DBSETPROP('v_items.nazwa', 'Field', 'UpdateName', 'items.nazwa')
=DBSETPROP('v_items.id', 'Field', 'UpdateName', 'items.id')
=DBSETPROP('v_items.id', 'Field', 'KeyField', .T.)
=DBSETPROP('v_items.nazwa', 'Field', 'Updatable', .T.)
=DBSETPROP('v_items.id', 'Field', 'Updatable', .T.)
=DBSETPROP('v_items', 'View', 'SendUpdates', .T.)
_________________

*|| Andrzej [NJ].
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform