Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I drop it?
Message
From
02/12/2013 06:01:15
 
 
To
01/12/2013 05:45:01
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:
01589021
Views:
83
>>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?
>
>
>The reason why you cannot is : the cursor contains a field with a name longer than 10 chars
>
>See message#1459597

I was about to post similar response. I got burned on that one myself.
Normally I never use field names longer then 10 chars. Problem was that I had one of those to be 11 - entered by mistake.
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform