Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I drop it?
Message
De
02/12/2013 06:01:15
 
 
À
01/12/2013 05:45:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01588891
Message ID:
01589021
Vues:
80
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform