Hi, I am a relative newbie using an older version of ElevateDB version 2.02 to be specific. I am running it on a Win 7 64 bit machine and I am having trouble with tables I am migrating from Dbisam using Delphi 5. I have no problem accessing the data in design time using the EDBTable control but every time I try to open my main catalogue file
using an EDBQuery control I get an access violation error:

'Access Viloation at address 0A169275 in module 'edb202d5run.bpl'. Read of Address 00000062.

the table currently has 14,278 records and one of my columns is a blob field with image data averaging about 1 meg.

What am I missing here?

Taji,

<< Hi, I am a relative newbie using an older version of ElevateDB version
2.02 to be specific. I am running it on a Win 7 64 bit machine and I am
having trouble with tables I am migrating from Dbisam using Delphi 5. I have
no problem accessing the data in design time using the EDBTable control but
every time I try to open my main catalogue file using an EDBQuery control I
get an access violation error:

'Access Viloation at address 0A169275 in module 'edb202d5run.bpl'. Read of
Address 00000062.

the table currently has 14,278 records and one of my columns is a blob field
with image data averaging about 1 meg. >>

Can you open the table in the EDB Manager ?  What about querying it ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

Taji,

<< Hi, I am a relative newbie using an older version of ElevateDB version
2.02 to be specific. I am running it on a Win 7 64 bit machine and I am
having trouble with tables I am migrating from Dbisam using Delphi 5. I have
no problem accessing the data in design time using the EDBTable control but
every time I try to open my main catalogue file using an EDBQuery control I
get an access violation error:

'Access Viloation at address 0A169275 in module 'edb202d5run.bpl'. Read of
Address 00000062.

the table currently has 14,278 records and one of my columns is a blob field
with image data averaging about 1 meg. >>

Can you open the table in the EDB Manager ?  What about querying it ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com


Hi Tim,

I have no problem whatsoever opening the table in the EDB Manager. In fact I have no problem opening it with
the EDB Query control if there are no images in the table at all, in design mode or when I execute a query
at run time. Everything seems to work as long as I don't save more that say 200 images to the table. There
are approximately 14,278 records in the table. As soon as I save more than about 200 images to the table
every time I try to open the table in design mode or at run time I get the error message. The average size of
the images I am trying to save to each blob field is 1.5 mb (1,566,774)

Taji,

<< I have no problem whatsoever opening the table in the EDB Manager. In
fact I have no problem opening it with the EDB Query control if there are no
images in the table at all, in design mode or when I execute a query at run
time. Everything seems to work as long as I don't save more that say 200
images to the table. There are approximately 14,278 records in the table. As
soon as I save more than about 200 images to the table every time I try to
open the table in design mode or at run time I get the error message. The
average size of the images I am trying to save to each blob field is 1.5 mb
(1,566,774) >>

So, you can open the populated table in the EDB Manager okay at run-time,
but not at design-time in the IDE ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

Taji,

<< I have no problem whatsoever opening the table in the EDB Manager. In
fact I have no problem opening it with the EDB Query control if there are no
images in the table at all, in design mode or when I execute a query at run
time. Everything seems to work as long as I don't save more that say 200
images to the table. There are approximately 14,278 records in the table. As
soon as I save more than about 200 images to the table every time I try to
open the table in design mode or at run time I get the error message. The
average size of the images I am trying to save to each blob field is 1.5 mb
(1,566,774) >>

So, you can open the populated table in the EDB Manager okay at run-time,
but not at design-time in the IDE ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

That is correct Tim. The table component works but the Query component doesn't.

Taj

Taji,

Make a backup copy of your source code, then do the following:

Try deleting the fields from the query's field editor (if there are any) and also comment out any events associated with the query, like OnCalc, OnAfterInsert etc. Then retest it.

Also I'd recommend downloading EurekaLog eval and have that running. If the program still crashes, it will help you find the cause of the exception.

Barry

Taji,

<< That is correct Tim. The table component works but the Query component
doesn't. >>

Yes, but that's not what I asked - what I asked was whether you can open the
table at design-time using a TEDBTable component vs. opening the table in
the EDB Manager.  Both use the TEDBTable and straight Delphi code, so they
should have the same result.  The same holds true for using a TEDBQuery
component at design-time vs. executing the same query in the EDB Manager.

We have to compare apples-to-apples in order to figure out what's going on.


Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

Taji,

<< That is correct Tim. The table component works but the Query component
doesn't. >>

Yes, but that's not what I asked - what I asked was whether you can open the
table at design-time using a TEDBTable component vs. opening the table in
the EDB Manager.  Both use the TEDBTable and straight Delphi code, so they
should have the same result.  The same holds true for using a TEDBQuery
component at design-time vs. executing the same query in the EDB Manager.

We have to compare apples-to-apples in order to figure out what's going on.


Thanks,

Tim Young
Elevate Software
www.elevatesoft.com


Yes Tim I can open the table using the TEDBtable component at
design-time and I can open the table in the EDB Manager as well.


Taji

Taji,

<< Yes Tim I can open the table using the TEDBtable component at design-time
and I can open the table in the EDB Manager as well. >>

So:

TEDBTable at design-time - good
EDB Manager table open - good
TEDBQuery at design-time - bad
EDB Manager query open - good

Does the EDB Manager version/build match that of the version of EDB that
you're using in your application ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

Taji,

<< Yes Tim I can open the table using the TEDBtable component at design-time
and I can open the table in the EDB Manager as well. >>

So:

TEDBTable at design-time - good
EDB Manager table open - good
TEDBQuery at design-time - bad
EDB Manager query open - good

Does the EDB Manager version/build match that of the version of EDB that
you're using in your application ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com


Hi Tim,

these are my actual results

TEDBTable at design-time - good
EDB Manager table open - good
TEDBQuery at design-time - bad
EDB Manager query open - Bad

When I tried to open the query in the EDB Manager
I got an error on execution -  'Out of Memory'.

and Yes I am using the same version of the Manager
and the components in my IDE.

Taji