block read from file is not a heap block

Hi,

I get he error in subject on my project when I try to delete a record.

Code is like:

(Some 'tweaking' of indexfields)

SetKey;

(set the values)

if GotoKey then Delete;

After delete I get the error in subject. Code is a conversion from an
old FF 1.x project so no SQL - yet. I first want to see the speed impact
Nexus has on the app

The table contains a blob field. I re-created the table from scratch
to make sure the table didn't contain any 'garbage'. I've
packed it - restructered it - emptied it. Still get the
error. Before emptying I got "Segment has been deleted".

Any ideas on how to get this bit working or atleast what the errors mean?
I searched for the "Segment has been deleted " error in this newsgroup and
from those
messages I decided to try the emptying.

--
Mikko Lappalainen, MH Software - my email address is invalid

> The table contains a blob field. I re-created the table from scratch
> to make sure the table didn't contain any 'garbage'. I've
> packed it - restructered it - emptied it. Still get the
> error. Before emptying I got "Segment has been deleted".

The error means that there is something wrong in one of the blob fields. Its
internal structure is invalid.

First, what version are you using? Second, if you are on the latest
(1.03.01) version, and you can reliably recreate the table with the error
from scratch from the FF1 table, I would like to know the exact steps to
reproduce.

> Any ideas on how to get this bit working or atleast what the errors
> mean? I searched for the "Segment has been deleted " error in this
> newsgroup and from those
> messages I decided to try the emptying.

In the EM, right-click the table and choose "Recover Records".

--


Eivind Bakkestuen [NDD]
Please, no email unless requested.
Search Borland and third-party newsgroups here: www.tamaracka.com

"Eivind Bakkestuen [NDD]" <Ieivind.bakkestuenHATE@nexusdb.comSPAM> wrote in
message news:400be29c$1@wic040d....
>
> First, what version are you using?

1.03.01 - of course

>Second, if you are on the latest
> (1.03.01) version, and you can reliably recreate the table with the error
> from scratch from the FF1 table, I would like to know the exact steps to
> reproduce.

I first used this conversion tool my collegue developed for FF1-Nexus
conversion.
But since I got the latter error from this table I re-created the table with
EM
'manually' defining the fields.

It'll be hard for me to create an example of the situation if that's what
you need.

What I do is add a record with blob field in it then search for that record
and delete it.
The problem only persists in this 'temporary' record I rarely use.
Haven't noticed the problem in other tables when searching and deleting
but not many of them have blobs. Blobs are stored in external file.

I'll try to create an example app, but it might be hard...

> > Any ideas on how to get this bit working or atleast what the errors
> > mean? I searched for the "Segment has been deleted " error in this
> > newsgroup and from those
> > messages I decided to try the emptying.
>
> In the EM, right-click the table and choose "Recover Records".

Table is empty now. I removed all data from it to make sure there was no
'garbage' in it.
Only the new 'temp' record is inserted in to that table and the error in the
subject occurs on every delete attempt. I can remove the record with EM.

--
Mikko Lappalainen, MH Software - my email address is invalid