>>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.