Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter Table Problem
Message
From
29/08/2002 12:36:44
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00694996
Message ID:
00695025
Views:
12
>Hello Everyone,
>
>I've Recently migraded and aplication that was compiled in VF6 to VF7, this aplication uses remote views to acces and SQL Server 2000 Database... i started having this problem with some views.. here the code:
>
>Use tablename alias Estructura
>=AFIELDS(ESTRUCTURA)
>CREATE CURSOR TCARTA FROM ARRAY ESTRUCTURA
>select tcarta
>alter table tcarta add column clave n(1)
>index on clave tag xxx
>
>
>I Get in the Alter Table Line "Invalid Operation for the Cursor" can anyone tell me how can i get pass this problem with VF7??
>
>Thanks

Jorge,
At least one field has a long field name. Add clave to array then create cursor :

=AFIELDS(ESTRUCTURA)
dimension estructura[alen(estructura,1)+1,16]
LOCAL lnNew
lnNew=alen(estructura,1)
estructura[lnNew,1] = 'clave'
estructura[lnNew,2] = 'N'
estructura[lnNew,3] = 1
estructura[lnNew,4] = 0
FOR ix=7 TO 16
estructura[lnNew,ix] = ''
endfor
CREATE CURSOR TCARTA FROM ARRAY ESTRUCTURA
index on clave tag xxx

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform