>Thanks Borislav, that's it.
>The decision to use non-production indexes was made before my time...
>I think one reason was to speed up appends by disabling indexing.

:) Adding 10 records and reindexing 100,000 is no savings. :)

Of course since there's a UDF in the index, that could make things slow enough to warrant such a tactic. ;)

>
>Howard
>
>
>>>When I executed a command like the following, I got an error indicating that 'File myproc.prg' does not exist.
>>>
>>>USE BMAIN.DBF INDEX BMAINI.CDX ORDER NAME SHARED AGAIN
>>>
>>>I included myproc in my program and the USE command now runs successfully.
>>>
>>>What can make the USE command execute code in my program?
>>>I looked for rules and triggers but do not see any associated with this table.
>>>
>>>Thanks,
>>>Howard
>>
>>Check your indexes, somewhere in them you use MYPROC() as statement.
>>Also WHY you use INDEX BMAINI.CDX? How you index your tables?