Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add memo field to cursor
Message
From
25/09/2007 14:08:32
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01256737
Message ID:
01256743
Views:
20
>Rich,
>
>See Re: Adding memo field as calculated field Message #683252
>
Thanks again



>
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform