I don't know why that happens. Maybe its a database corruption issue. To handle things of that nature, get one or both of the following:

Stonefield Database Toolkit (SDT) web site

Recover from Abri web site

As for making it easier to update your SPs if it happens again, keep a copy of your SPs in PRG form. If you need to reinitialize again, use APPEND PROCEDURES FROM MYSPs.PRG OVERWRITE.

HTH.

>I've came across twice the store procedure suddenly blank(empty) and i have to rewrite all the referential integrity code. Why ??
>
>
>> My personal preference is referential integrity code should be in stored procedures. That way, no matter how the data is accessed (e.g. any form in your application, outside ODBC source), that code will get fired and your data will not get corrupted.

Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao