Solved

Currupt tables after going from 16 to 32 bit

Posted on 2002-06-06
11
147 Views
Last Modified: 2010-04-04
Hello,

We recently upgraded our 16 bit Delphi application to 32 bit for our users.  Each user has 3 Database tables.  
In some instances, after installing the software their tables appear to be corrupt. The users would get "Master record Missing" errors when attempting to add date.

It appears that there are ophen records in the third table. To fix it...we do a query on the table and save it. Then we go into the table via Paradox and delete all the records and then import the saved query. The ophen records are then rejected.

Is there any way to fix this or an easier way to fix it so we aren't bombarded with problems when they all start installing it at once.
0
Comment
Question by:reenie1
  • 5
  • 4
  • 2
11 Comments
 
LVL 27

Accepted Solution

by:
kretzschmar earned 200 total points
ID: 7060043
you could use a simple query like

delete from childtable where master_id not in (select id from mastertable)

not tested

meikl ;-)

0
 
LVL 6

Expert Comment

by:swift99
ID: 7061137
I would be concerned about orphan records.  

One of your processes is performing a partial commit or partial rollback, or possibly the master record delete process is incomplete.  Or, of course, you may simply have exposed a bug in the referential integrity of an earlier version of the BDE.

Cleaning up the data is one thing, but you want to be certain of _why_ the records are orphan before committing to a code release.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7061190
>certain of _why_ the records are orphan before
>committing to a code release.

guessing in the earlier release was no referential
integrity implmented

>performing a partial commit or partial rollback

not possible with paradox-tables (no sql server)

meikl ;-)
0
 
LVL 6

Expert Comment

by:swift99
ID: 7061212
> not possible with paradox-tables (no sql server)

meikl: too true.  I've been out of the ISAM world too long.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7061220
>I've been out of the ISAM world too long.
i too, but some cases i can remember :-))
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 6

Expert Comment

by:swift99
ID: 7061332
> not possible with paradox-tables (no sql server)

but it is possible that the buffers were not flushed fully when the application terminated ...
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7061345
yes, but only by an abnormal abend->means crash
0
 
LVL 6

Expert Comment

by:swift99
ID: 7061356
they must have fixed things in the BDE since I last used it for ISAM work.  I used to have no end of problems if I didn't explicitly call its flush bufers method with paradox tables before closing the app.   :o)
0
 

Author Comment

by:reenie1
ID: 7061785
The strange thing is that the orphan records were dated 1998. We created this system in 99 and users could only add years from 1999 and up (the year is part of the key)
We did not allow them to add detail records without a master record for any particular year.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7061887
seems something went wrong with the 16 bit app,
maybe the user adds master and details for 1998 by mistake
and then the user deletes the master-record

is this possible in the old app?

meikl ;-)
0
 

Author Comment

by:reenie1
ID: 7063102
I wasn't sure who to award points to but I guess since you were the first and i'll have to delete the masterless children..you get the points.

I think you were all correct in that there were referential integrity problems in the prior version because i now remember some users lost master records..and when they were readded, the child records showed up. So apparently the children remained in the table even thought the parent was gone.

Thanks everyone.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
delphi custom sort exception 6 136
Working with hours 3 46
Unique identifier on a terminal server (rdp) 4 46
How to create virtual printer while installing my application 5 24
The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now