Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Unanswered: checked field not in answer.db

    I am performing a qbe query within a method on a pushbutton, however one of the checked fields is missing within the answer table when the query is run. If I perform the same query interactively then the field is present in the answer table. I have tried both executeQBEfile("test.qbe") and using a query variable with the query pasted into the method. Not sure what is causing this but may be related to Paradox hanging more and more frequently at random.

    Paradox V10 running on W7

    Anyone got any idea why this should be happening?


  2. #2
    Join Date
    Dec 2007
    unless there is file damage, the only reason for no field in the answer is when there are no values in the field or no values in the result.. when you run "the same query" with different results, that usually means that something is wrong.. most likely, damaged or out-of-synch index files..

    make sure you have backups.. rebuild with the repair tool.. restruct to pack the table and rebuild the indexes.. validate the results..
    Steven Green - Myrtle Beach, South Carolina USA

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

Posting Permissions

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