Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Altering a CUSOR's structure
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00062738
Message ID:
00063272
Vues:
71
>>Mark McCasland sent me a solution to my original question. Any cursor created with CREATE CURSOR can be modified with ALTER TABLE (Cursor Alias). Assuming that Microsoft does not view this as a bug, or intends to provide an ALTER CURSOR command in the future, then this approach should serve my needs.
>Edwin,
>
>Using SELECT ... INTO CURSOR will work too and it won't require altering the structure as the structure is set each time you select.

Excellent. I had hoped that ALTER TABLE would let me change a cursor's structure (add fields) without disturbing bound controls such as
grids, but a little experimentation has disabused me of that notion. It looks like VFP deletes and recreates a cursor when its structure is altered via ALTER TABLE. SELECT ...INTO CURSOR should do the same and its easier that ALTER TABLE ADD COLUMN, DROP COLUMN.
Thankyou.
Ned

Reality is.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform