Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Altering a CUSOR's structure
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00062738
Message ID:
00063272
Views:
69
>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform