Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I drop it?
Message
From
01/12/2013 05:34:24
 
 
To
30/11/2013 15:37:40
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01588891
Message ID:
01588949
Views:
61
Then just list the fields you want to export, and rule this field out. Depending on how you export, you may even be able to use the keyword Except.

Another solution is to select the necessary fields from the cursor into a new cursor. If the source is a readwrite cursor, you can even use the same name for the destination cursor.

>In this situation it hurts ;-)
>
>The thing is that the resulting cursor is exported to an excel file.
>
>>It's a cursor, just leave the extra column as is, it doesn't hurt.
>>
>>>I created a cursor. I did some additional processing after that cursor was created. Now there's a column I don't need anymore.
>>>
>>>How do I get rid of that column?
>>>
>>> I tried the following
>>>
>>>ALTER table NameOfCursor drop column NameOfColumn
>>>
>>>Didn't work.
>>>Error 1115 : Invalid operation for the cursor.
>>>
>>>Is the only solution creating another cursor and selecting only the needed columns from the original cursor?
Previous
Reply
Map
View

Click here to load this message in the networking platform