Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I drop it?
Message
De
30/11/2013 18:24:52
 
 
À
30/11/2013 15:32:38
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:
01588932
Vues:
81
I believe you can ALTER TABLE of a
CREATE CURSOR ...
not a
SELECT ... INTO CURSOR ..., even READWRITE


>Bonjour Thierry,
>
>Not sure if it's what you wanted but just an ordinary cursor.
>
>Select Field1, field2 from WhateverTable into cursor cResultingCursor readwrite
>
>>How is the cursor created?
>>
>>>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?
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/
Never explain, never complain (Queen Elizabeth II)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform