Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2013
    Posts
    2

    Unanswered: Referential integrity problem

    Hi
    I have a number of tables linked to a master table using RI.
    Recently I added another table, no problem, but when I came to add 1 more, when I pressed save I got table is busy message. I exited PD & went back in. Same problem.
    I ended up getting around the problem by copying Master table with new name, exporting child tables, re-importing & setting up RI again. I wondered if it was due to too many tables linked, so I drastically reduced the number (I think there are 6 tables linked now).
    I had noticed that when I exited PD I often got a message asking if I wanted to save the table view properties (for master table, that I hadn't changed). I always said No. Also, when I opened PD, if the master table was closed when I exited, it flashed up briefly then closed again when I opened PD.
    I thought I had sorted the problem with my exporting/importing etc, but I had the same thing today with master table flashing up & asking if I wanted to save changes. To test, I went into child table & tried to save - got table is busy message. Any ideas??
    I have been using PD since v4.5, now on V10, Win 7 64-bit pro, 8GB RAM, all Windows updates applied
    Thanks in advance.

  2. #2
    Join Date
    Dec 2007
    Posts
    369
    the truth is, long-term Paradox developers have always recommended that you NOT use RI.. problems like this, and problems way worse than this, can happen, especially if one or more files get un-synched or corrupted..

    master-detail relationships are an ordinary part of data structure.. you must handle the adds and deletes yourself, in your app

    if you have technical questions in this area, you should post them on the "paradox community" group, not here

    Support - Paradox Community
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

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

  3. #3
    Join Date
    Jul 2013
    Posts
    2
    Thanks will go there

Posting Permissions

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