>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