Our Pervasive 10.10 DB is consistently loosing views.

One day they are there (in the PCC) and then all of a sudden they are no longer showing up in the PCC. They still function via SQL calls but we can't see them.

Any ideas would be appreciated.

Bill Slaughter
bwls@earthlink.net

I've never seen that behavior.
If you issue a "SELECT * FROM X$VIEW", are they returned in the results?
What about the "psp_views" system stored procedure (executed by "call psp_views(,)")? Does it return anything?

Yes. The view does work. The problem is that it is not being displayed when in the Pervasive Control Center. (PCC).

Thanks,
Bill