Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I drop it?
Message
De
30/11/2013 15:36:04
 
 
À
29/11/2013 12:01:42
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
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:
01588929
Vues:
63
>>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?
>
>Which shouldn't be that hard:
>
afiel(aF,"nameOfCursor")
>lnElement=ascan(af, "myfieldname") && mind the other parameters here - case sensitivity, perhaps search only column 1
>lnRow=asubscript(af, lnElement, 1) 
>adel(af, lnRow)
>dimension af(alen(af,1)-1, alen(af,2))
>
>create cursor newname from array af
>append from dbf("nameOfCursor")
Interesting code Dragan. It's not what I wanted to do but I appreciate the alternative.

I thought about doing the following

Original query would be like
select field1, field2, FieldThatWillBeDropped from MyTable into cursor cTemp

Final query would be like
select field1, field2 from cTemp into cFinalCursor
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform