What I am trying to do is convert a table from a DOS TP program I wrote
years ago to a new table in D4. I have done this many times before with
larger tables than this one. The following are the specs of the source
and target Paradox tables.

Source Table:  Level 4, Field count=107, Record size=1147, Records=11688

Target Table: Level 7, Field count=68, Record size=1150
Both have 4 indexes.

I am get an error about 10250 records into the source file. The error
simply displays as 'Access violation at address ____. Read at address
____'. I don't think the address is significant in that it changes
depending on when the program runs. If it is, let me know.

I don't understand what this error means. I am running on a PII 350,
with 64MB RAM. I have tried running outside of the IDE with nothing else
running, except some background stuff, hoping that if it is a memory
issue that would be out of the way.

Any ideas what is this error is trying to tell me? Thanks in advance for
any suggestions.

dick Mathews

It could be that your old table is corrupt.
How are you going about inserting the source table into the target?

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

Brian,

I am reading each field from source into a field in the target like

TargetTable.Insert;
TargetTableFieldname.Value := SourceTableFieldname.Value;
........

TargetTable.Post

I thought about corruption also. I looked at the source around that record
and looked good. I tried deleting a few records before and after. It still
errors out at approximately the same record.

dick Mathews

It could also be a memory-leak of some kind, of course.  But easily the
best way to handle operations like that is with the TBatchMove
component.

--
--------------------------------------------------------------------
Sundial Services :: Scottsdale, AZ (USA) :: (480) 946-8259
mailto:i...@sundialservices.com  (PGP public key available.)

Have you updated the BDE version you are using?  Have you updated Delphi 4 with
the available updates.  If you are running from the original release of D4 that
may be your problem.

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

Brian,

I am running D4 with update pack 3 and BDE v5.01. I think these are close if not
the latest.

This may be a corruption problem, even though it appears good when viewed by the
DBD. I found it was corrupted when I returned to my machine after making a copy of
it at the client site. I used my old version of Tutility to repair the table. I
viewed this file with my original version of the DOS program and it worked ok. Thus
thinking the repair was successful.

I am going to get a new copy and try that one and see if that one works ok.

dick Mathews

Barry,

I kept looking at the record that it issued the AV and saw nothing. That doesn't
mean that there isn't. I deleted 4 or 5 records before and after that record and
it still died at the same place. That's what's wierd. Unless the remainder of
the records are corrupted, that should have deleted the bad record.

dick Mathews