>>When Trying to open a table in a database I get tan error saying xxx.prg does not exist. I click ok and the table opens fine. Is there anyway to overcome this error?
>
>Does it happen with other tables in the DBC? Do you've an index on that table that includes xxx() in the index key? Maybe indexes on that table got corrupted? Did you try
VALIDATE DATABASE RECOVER
Sergey,
You are correct that one of the indexes on this table has
'xxx("CPRODID",prodid,"CDESCRIPT",descript,"CLOCATION",location,"CVENDOR",vendor,"CCATEGORY",category,"CDEPART",depart,"CMANUFACT",manufact,"CMODELS",models,"MNOTES",LEN(notes),"MINVCNOTE",LEN(invcnote))'
in the expression. This is a database belonging to another system I am just trying to write a unique report against it.
Thanks