Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add memo field to cursor
Message
From
25/09/2007 13:56:13
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Add memo field to cursor
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01256737
Message ID:
01256737
Views:
65
I have a cursor created via
SELECT fieldlist FROM myTable WHERE conditions INTO CURSOR myCursor READWRITE
I would like to add a memo field to myCursor but haven't quite figured out the syntax for either ALTER TABLE myCursor (Invalid Operation) or modifying the SELECT statement.

Is there something cleaner than
SELECT fieldlist FROM myTable WHERE conditions INTO TABLE myTmpTable
ALTER TABLE myTmpTable ADD newmemofield M
SELECT * FROM myTmpTable INTO CURSOR myCursor READWRITE
DELETE FILE myTmpTable.*
Thanks.........Rich
Next
Reply
Map
View

Click here to load this message in the networking platform