Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009
    Posts
    14

    Thumbs down Unanswered: Pervasive DB Views

    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

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Jan 2009
    Posts
    14
    Yes. The view does work. The problem is that it is not being displayed when in the Pervasive Control Center. (PCC).

    Thanks,
    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •