Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updateable Cursor - how?
Message
 
À
24/09/1999 13:48:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00268624
Message ID:
00268634
Vues:
17
>How would I create a cursor from a select statement, accessing a VFP table, and be able to update that cursor?
>
>TIA
>
>/Chris

First create the cursor as usual.

Then look at the help for CURSORSETPROP. You can pass several parameters, but the first parameter is the property of the cursor you want to set. You will need to set several properties including Tables (the tables you will be updating), UpdatableFieldList (the fields that you want to be able to update), KeyFieldList (which fields are key values so the update can find the right record to update), UpdateType, and WhereType. There may be some other options you want to set, but I think this is the core set. Basically it sets the same properties that you would set visually when you design a View.

Mike
Michael P. Antonovich, MCSD
Email: mike@micmin.com
MicMin Associates - Orlando, FL


Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform