Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to have updatable cursor to underlying table?
Message
De
22/03/2003 17:30:26
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
22/03/2003 05:36:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00768880
Message ID:
00768977
Vues:
17
>Hi,
>How could I have updatable cursor that will syncronize the changes of cursor to underlying native table programmatically?
>I know that I can use local view, but i would like to know is there other ways.
>Also, there is cursorapdapter in vfp8, but i have no luck to upgrade to it yet...
>
>any ideas?
>
>Thank you

The view is precisely an updatable cursor, almost by definition. I don't think VFP has another "easy" way to achieve the same result.

You could use a regular cursor, but then you would have to take care of all the synchronization yourself (detect what records have changed, locate the records in the underlying table, update them).

The view does all this automatically for you, so I would suggest to simply use views.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform