Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Invalid BLOB offset
Sat, Jun 3 2006 7:17 AMPermanent Link

"Frans van Daalen"
Does anyone know how to save data from a memo field  (or beter the complete
table) when hit by "Invalid BLOB offset...." ?

Frans

Sat, Jun 3 2006 4:25 PMPermanent Link

"Mike Shkolnik"
As I see from help file, you may try to execute the RepairTable method for
TDBISAMTable component

--
With best regards, Mike Shkolnik
E-mail: mshkolnik@scalabium.com
WEB: http://www.scalabium.com

"Frans van Daalen" <Account@is.invalid> wrote in message
news:EC0E35F0-5692-4001-9CA0-C06F07300964@news.elevatesoft.com...
> Does anyone know how to save data from a memo field  (or beter the
complete
> table) when hit by "Invalid BLOB offset...." ?
>
> Frans
>
>

Sun, Jun 4 2006 5:17 AMPermanent Link

"Frans van Daalen"

"Mike Shkolnik" <mshkolnik2002@ukr.net> wrote in message
news:98DFCD5D-EF3A-413D-B9A4-EE319296324D@news.elevatesoft.com...
> As I see from help file, you may try to execute the RepairTable method for
> TDBISAMTable component
>
that will delete the value of the memo field for all records, i need
somethink to keep that value.

Mon, Jun 5 2006 9:57 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Frans,

<< that will delete the value of the memo field for all records, i need
somethink to keep that value. >>

If the BLOB offset is incorrect for a BLOB field, then the data is already
lost.  Are you getting this error for all of the BLOB fields, or just some ?
If it is all of them, then most likely the BLOB (.blb) file was overwritten
with a copy from a different table.  Sometimes this happens when a
user/developer copies the files around and forgets to copy the .blb file.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Jun 6 2006 4:06 AMPermanent Link

"Frans van Daalen"

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:3D2068C8-8DE6-411D-A87F-98DB44CE9C52@news.elevatesoft.com...
> Frans,
>
> << that will delete the value of the memo field for all records, i need
> somethink to keep that value. >>
>
> If the BLOB offset is incorrect for a BLOB field, then the data is already
> lost.  Are you getting this error for all of the BLOB fields, or just some
> ? If it is all of them, then most likely the BLOB (.blb) file was
> overwritten with a copy from a different table.  Sometimes this happens
> when a user/developer copies the files around and forgets to copy the .blb
> file.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>
arg.....Thank you, I did get a copy from a customer with a problem and
forgot to ask the .blb file. Hence the trouble I was in...Thanks for the
reminder.

Image