Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter table
Message
 
 
To
04/03/2002 11:46:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00627857
Message ID:
00627872
Views:
16
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
Previous
Reply
Map
View

Click here to load this message in the networking platform