I suppose you create index in the application in run time. Something like:
_variable="hello"
index on field_name+_variable tag hello

If it is the case, then you have two choices.
- Remove index when closing application, or
- Create indexes other way:
lccom="index on field_name+'"+_variable+"' tag hello"
&lccom

Good luck

>Afternoon all (Morning for some of you)
>
>I have a table which has a corrupt index expression
>Ie there is an index in the table which points to a field which does not exist
>
>Each time I open the table it gives an error "Variable 'OD_CD' is not found." (In fact it should be prod_cd)
>
>It's easy enough to fix this issue.. I could just do a delete tag all & recreate (or similar)
>
>But I was wondering how do I detect this kind of issue programatically?
>If I do something like the following:
>

>llFlag = .f.
>On error llFlag = .t.
>Use table in 0
>
>If llFlag
>  Wait Window 'Error occurred'
>EndIf
>

>the flag is not set correctly & a VFP error still comes up, which I don't want my users to see.
>
>Does anyone know of a way to either trap for this kind of error or detect the issue in the dbf? (I can see a million suggestions for SDT coming in my direction)
>
>TIA
>
>Will