Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 8 of 8 total
Thread BDE transfer utility misterious problem...
Wed, May 24 2006 7:32 AMPermanent Link

"Santy Concepción"
Hi!

I need to convert old BDE (paradox) tables to DBISAM.
I have made a little utility for my customers, so they can convert the old
databases to DBISAM.

Sometimes, my little converter shows an access violation when converting
some tables, errors like "Out of Memory", etc...

So, I tried to make the conversion using your BDE Transfer Utility, and the
error persists!

BUT...

There are 20 tables.
If I convert the first 10 tables, and then the other 10 tables, then NO
ERROR OCCURS!
But if I convert all the 20 tables at a time, then the error occurs

It happens when converting bif tables, with about 50,000 records, etc...

Maybe a memory leak, not "freeing" any objects, etc...

Thanks!

Wed, May 24 2006 5:46 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Santy,

<< There are 20 tables.
If I convert the first 10 tables, and then the other 10 tables, then NO
ERROR OCCURS!
But if I convert all the 20 tables at a time, then the error occurs

It happens when converting bif tables, with about 50,000 records, etc... >>

Are you specifically getting a DBISAM error, or a general Delphi runtime
error ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, May 25 2006 4:45 AMPermanent Link

"Santy Concepción"
Hi, Tim...

These are the errors I get:

There are 20 tables.
If I select ALL, the error occurs whern transfering table #9 (table #8 is
very big):

1) Access Violation at address 4CE0E91C in module IDPDX32.DLL. Read of
address 01BB2000

I press "Begin Transfer" again and I get the following error:

2) "Out of memory"

Ok, now I CLOSE and REOPEN the 'BDE Transfer Utility' and I select ONLY
tables from #9 to #20 and press "Begin Transfer" again.

Now Table #9 is transfered correctly :-/

I made a code 'step by step' to the BDE Transfer Utility and the error seems
to be "List index out of bounds" when transfering table #9
But Why??

Can I send you the tables (compressed) so you can test it?

Thanks!



"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> escribió en el
mensaje news:6A9EA1E5-F603-4DDF-B668-9ED37D9853D0@news.elevatesoft.com...
> Santy,
>
> << There are 20 tables.
> If I convert the first 10 tables, and then the other 10 tables, then NO
> ERROR OCCURS!
> But if I convert all the 20 tables at a time, then the error occurs
>
> It happens when converting bif tables, with about 50,000 records, etc...
>  >>
>
> Are you specifically getting a DBISAM error, or a general Delphi runtime
> error ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Thu, May 25 2006 7:46 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Santy


I'm talking way out of my knowledge area here, but as a guess are there any large memo fields involved. I sort of remember this as a problem.

Roy Lambert
Thu, May 25 2006 7:33 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Santy,

<< Can I send you the tables (compressed) so you can test it? >>

Sure, but it sounds more and more like a BDE/Paradox issue, so I can't
guarantee that I will be able to do anything other than confirm the problem.

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, May 26 2006 2:33 PMPermanent Link

"Santy Concepción"
Hi, Roy...

Yes, some of the tables affected have MEMO fields.
Does it mean that my customers can't install the new version?

"Roy Lambert" <roy.lambert@skynet.co.uk> escribió en el mensaje
news:F31B2053-FEA1-4115-8CDC-58054635BA95@news.elevatesoft.com...
> Santy
>
>
> I'm talking way out of my knowledge area here, but as a guess are there
> any large memo fields involved. I sort of remember this as a problem.
>
> Roy Lambert
>

Sat, May 27 2006 5:56 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Santy


What version of DBISAM are you using? I can't remember if it was a BDE problem or a DBISAM one. Either way you may have to alter your software to export to an intermediate format and then import from there.

Roy Lambert
Sun, May 28 2006 5:18 PMPermanent Link

Santy Concepcion
hi, Roy.

I'm using the latest DBISAM version.
I don't think the problem is involved to MEMO fields, because the table that fails doesn't have any MEMO or BLOB fields Frown
And if I re-convert the tables then it is converted correctly the second time!

Tomorrow I will try to converte all teh tables ExcLUDING the MEMO/GRAPHIC fields, just to test if the error occurs.

Thanks!


Roy Lambert <roy.lambert@skynet.co.uk> wrote:

Santy


What version of DBISAM are you using? I can't remember if it was a BDE problem or a DBISAM one. Either way you may have to alter your
software to export to an intermediate format and then import from there.

Roy Lambert
Image