>>>>is possible to create a calculated field in a VFP table?
>>>You need to create a view on the table and use that view
>>
>>Thank you.
>>I need an index on computed field :(
>
>You can index a view -
>
>

>&& form load 
>use viewname in 0 nodata
>select viewname
>index on fieldname tag xxx
>
>&& later 
>Viewparam1 = ...
>
>=Requery('viewname')
>

Hi Gregory

try

&& form load 
use viewname in 0 nodata
select viewname
index on fieldname tag xxx

&& later 
Viewparam1 = ...

=Requery('viewname')

index on fieldname2 tag xyz

fo all I remember it was

INDEX ON fieldname2 TAG xyz OF CDX(1) ADDITIVE

edit:

Cursordapter needs same solution.
INDEX ON creates a cdx based on dbf(). Every REQUERY() changes the dbf(), so the second INDEX ON will try to create a second cdx file