Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alter table
Message
 
 
À
04/03/2002 11:46:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00627857
Message ID:
00627872
Vues:
19
Joseph,

Why not use SQL to create it in one step?
select *, 000000000000.0 as frominv, 00000000000.0 as frompo ;
   into cursor orditemview readwrite ;
   where ...
I'm not sure why your array based code is no longer working though. I generally use code like above to create cursors with alternate structure.

>I have recompiled my application in Visual Foxpro 7.0. from 6.0. Can I no longer alter a cursor in the following manner? If not, then what should I do instead to generate a temp. copy of a table with alterations?
>
>SELECT neworditems
>ordnumfields = afields(orditemfieldarray)
>CREATE CURSOR orditemview FROM ARRAY orditemfieldarray
>ALTER TABLE orditemview ADD COLUMN frominv N(12,1)
>ALTER TABLE orditemview ADD COLUMN frompo N(12,1)
>
>
>
>I get the error msg:
> Invalid operation for the cursor.
> alter table orditemview add column fromin n(12,1)
> error Number :1115
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform