>>>>>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 -
>>
>>
>>
>>use viewname in 0 nodata
>>select viewname
>>index on fieldname tag xxx
>>
>>
>>Viewparam1 = ...
>>
>>=Requery('viewname')
>>
>
>Hi Gregory
>
>try
>
>
>use viewname in 0 nodata
>select viewname
>index on fieldname tag xxx
>
>
>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
I don' t know, but that is what I do
(1) I only index a view once - before the first requery()
(2) I use the index command as I wrote
Gregory