My app ( Paradox on Delphi 3.01 ) is getting a database error "Master
Record Missing" when inserting a new record in a transaction file.

    I have no referential integrity set up between the tables in question
 transaction file and customer file ). The error occurs when a transaction
does not have an existing customer record in the customer file.

    Originally, I set up referential integrity between the tables using the
desktop database. However, I eliminated the referential integrity between
these tables using the database desktop.

    There are numerous instances where I need to add the transaction record
prior to creation of the customer record. This is why I took the referential
integrity out of the two files.

    What has happened here ??? Do I have some file corruption of the .Val
file ??? What can I do to resolve this situation ???

    Thank you for your help.

Sincerely,

Neil Huhta

Steve:

    I checked the referential integrity of both files prior to posting this
message. I also checked among every other file in the sub-directory -
again - no RI is shown.

    How could I rebuild these files to ensure that there is no corruption in
the VAL file ???

    What other procedures would you suggest ???

    Thank you.

Neil Huhta

On Mon, 23 Nov 1998 18:39:53 -0500, "nhuhta" <nhu...@digital.net>
wrote:

Well, it could be VAL file corruption. However, entries for RI are in
the VAL files for both tables. Therefore, if you've eliminated it in
one, it's possible that the other file still thinks RI is in place.
This can happen if you've restored one table of the pair. You may want
to look at all the tables in the Database Desktop in case the RI is
still there in places you don't expect.

Steve F (Team B)

I belive you still have referential integrity link between these two table.
I have never seen this error come from anything else.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Hi nhuta,
you should check "referential integrity" pane in Database desktop
for *detail table*. For *master table*, you should check
"dependent tables" pane. If you will find that master table
still refers to detail in its "dependent tables" listing, it will indicate
that you removed referential integrity in a copy of database
and copied back only the detail table files. You should allways
manipulate referential integrity in the original database.
--
Roman
(please remove STOPSPAM. in header)
URL:  www.rksolution.cz (Delphi corner)
MAIL: I...@rksolution.cz

Brian,

        You are correct. The transaction file still had the referential
definition defined. I was transferring data between 2 sets of
identical files and must of got mixed up with the database desktop.
My error.

Neil Huhta

Brian Bushay TeamB <BBus...@Nmpls.com> wrote in article
<36654867.47982781@floyd>...