Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Altering the structure of a cursor
Message
From
04/01/2008 17:33:31
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Altering the structure of a cursor
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01279520
Message ID:
01279520
Views:
71
What would prevent me from altering the structure of a readwrite cursor?

In two different locations in my application, I am creating a readwrite cursor and then dropping the memo fields because I later want to do a union and you can't union cursors with memo fields.

I know several work arounds, but I am puzzled since dropping a field works fine in one instance and is failing in another.

So here is some sample code:
* mhistory here is the memo field
select cfirst, clast, mhistory ;
 from customer ;
 where clast = "Brown" ;
 into cursor cur_selectedcustomers ;
 readwrite

alter table cur_selectedcustomers drop column mhistory
The error I am getting is: Invalid operation for the cursor (Error 1115)

Which from the VFP help is: An attempt was made to use the PACK command on a cursor.
Carole Shaw
Fred Hutchinson Cancer Research Center

Eagles may soar, but weasels don't get sucked into jet engines.
Next
Reply
Map
View

Click here to load this message in the networking platform