Sorry about the previous message - it was sent by mistake.

Hi.

I have a table with two blob fields (and several others).
I want to alter the structure of the table - in this case add a couple of
fields.
In Dbsys everything works as expected, however when I open the altered table
in my application I get:

DBISAM Engine Error # 8963 BLOB block buffers corrupt in the table 'MyTable'

If I try to open the table using Dbsys, it seems to be ok.

I have tried to repair the table, but the issue prevails.

What is wrong?

I have emptied the table, altered, then populated the table with data. This
seems to work.
Should not Dbsys be able to alter tables with blob data in them?

Br.
Petter Topp
Dbisam 4.29

Petter,

<< I have a table with two blob fields (and several others).  I want to
alter the structure of the table - in this case add a couple of fields.> In
Dbsys everything works as expected, however when I open the altered table in
my application I get:

DBISAM Engine Error # 8963 BLOB block buffers corrupt in the table
'MyTable'

If I try to open the table using Dbsys, it seems to be ok.

I have tried to repair the table, but the issue prevails.

What is wrong? >>

Can you send me the table that you're experiencing the issue with ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim.

I sent you the table to support@elevatesoft.com in a zip file (4Mb)

Petter

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> skrev i melding
news:07CAFB89-83B4-42AE-AA2F-21BD891379F6@news.elevatesoft.com...
> Petter,
>
> << I have a table with two blob fields (and several others).  I want to
> alter the structure of the table - in this case add a couple of fields.>
> In Dbsys everything works as expected, however when I open the altered
> table in my application I get:
>
> DBISAM Engine Error # 8963 BLOB block buffers corrupt in the table
> 'MyTable'
>
> If I try to open the table using Dbsys, it seems to be ok.
>
> I have tried to repair the table, but the issue prevails.
>
> What is wrong? >>
>
> Can you send me the table that you're experiencing the issue with ?
>
> Thanks,
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Hi Tim

Posted it in Binaries, got some problems sending by mail.

Petter

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> skrev i melding
news:07CAFB89-83B4-42AE-AA2F-21BD891379F6@news.elevatesoft.com...
> Petter,
>
> << I have a table with two blob fields (and several others).  I want to
> alter the structure of the table - in this case add a couple of fields.>
> In Dbsys everything works as expected, however when I open the altered
> table in my application I get:
>
> DBISAM Engine Error # 8963 BLOB block buffers corrupt in the table
> 'MyTable'
>
> If I try to open the table using Dbsys, it seems to be ok.
>
> I have tried to repair the table, but the issue prevails.
>
> What is wrong? >>
>
> Can you send me the table that you're experiencing the issue with ?
>
> Thanks,
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Petter,

<< Posted it in Binaries, got some problems sending by mail. >>

Is this the table before the alteration, or after ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Before alteration.

Petter


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> skrev i melding
news:5D1B986B-5034-4F59-BE37-9F467D15A76B@news.elevatesoft.com...
> Petter,
>
> << Posted it in Binaries, got some problems sending by mail. >>
>
> Is this the table before the alteration, or after ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Petter,

<< Before alteration. >>

I tried adding a string field and an integer field to the end of the
structure, and then ran a repair on the table after the alteration, and the
table checks out just fine.

Could you tell me which alterations you're trying to make to the table ?

Also, just so you know, I did do a repair on the table before I started the
alteration, and it indicated that the indexes were corrupted.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim.

I just discovered that I have created and altered the tables using Dbsys
ver. 4.29 while running VCL 4.26.
This is probably the problem or?

Petter


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> skrev i melding
news:E207F1C4-0E2A-4D94-AEC0-80BA484B8B86@news.elevatesoft.com...
> Petter,
>
> << Before alteration. >>
>
> I tried adding a string field and an integer field to the end of the
> structure, and then ran a repair on the table after the alteration, and
> the table checks out just fine.
>
> Could you tell me which alterations you're trying to make to the table ?
>
> Also, just so you know, I did do a repair on the table before I started
> the alteration, and it indicated that the indexes were corrupted.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Petter,

<< I just discovered that I have created and altered the tables using Dbsys
ver. 4.29 while running VCL 4.26. This is probably the problem or? >>

Yes, that will be a problem.  Do you have a copy of the table that was not
touched using 4.29 ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim.

I have just purchased a support plan for Dbisam, and then I will have access to 4.29 as soon as you have processed my order.

Br
petter

"Tim Young [Elevate Software]" wrote:

Petter,

<< I just discovered that I have created and altered the tables using Dbsys
ver. 4.29 while running VCL 4.26. This is probably the problem or? >>

Yes, that will be a problem.  Do you have a copy of the table that was not
touched using 4.29 ?

--
Tim Young
Elevate Software
www.elevatesoft.com