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

    Question Unanswered: Zero Records in PCC but table Has Data

    We have a table that shows in PCC with 0 records but when acessed via Brieve there are over 2500 rows in the table. How can we fix this?

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Sounds like the DDF isn't pointing to the same data file. If you right click the table in the PCC and select Properties, it will show the Table Location. Make sure it's what you expect. To change it, you can issue an ALTER TABLE statement with USING and IN DICTIONARY clauses. The USING clause tells PSQL which data file to use and the IN DICTIONARY tells it to only affect the DDFs and not the data file too.
    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.

Tags for this Thread

Posting Permissions

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