Well, Prior to archiving the audit I ran sdt's reindex routine.
It must have something to do with FoxAudit.
By the way FoxAudit Archive routine is VERY strange. It seems to eliminate records from NOW to a entered date rather everything PRIOR to the entered date wich would make a lot more sense.
Peter
>Maybe indexes got corrupted on this table? Try to recreate them.
>
>>I have been running an app which uses FoxAudit version 6.0 for a couple of years now. Until this morning it worked floawlessly.
>>This morning I ran oFoxAudit.Archive and now I get a error on some tables:
>>
>>Error# 152
>>Message Missing Expression
>>Program FoxAudit
>>Object
>>Source Code: EVAL(SYS(14,lnKount,lnArea))
>>
>>And it does not save the record.
>>
>>
>>HEEEEEELP
>>
>>
>>Peter
Peter Cortiel