I have a problem that takes several steps to recreate.

(DBISAM 4.22 Build 6 in C/S mode, Delphi 5)

Taking a certain action in my app somehow creates a duplicate of the
current record.  It would appear that this record is a duplicate in every
way, right down to the auto-incrementing ID field, and presumably to the
contents of blob offsets in the blob fields.  I then use DBSys to delete
one of the duplicate records, and this corrupts the table.  On accessing
the original record, I get and error # 8963 BLOB block buffers corrupt in
the table 'Assignment'.  If I then repair the table, the contents of all
the blob fields in the record are gone.  Presumably, deleting the second
record wiped out the blobs that the first record was referring to.

As for the "certain action" in my app that starts this sorry chain of
events...  The VCL for the DBNavigator, when handling a click on the Post
button, appear to make a nested call to an OnExit handler of mine which
also contains a Post call.

--Bill Sparrow--

Bill,

<< (DBISAM 4.22 Build 6 in C/S mode, Delphi 5)

Taking a certain action in my app somehow creates a duplicate of the
current record.  It would appear that this record is a duplicate in every
way, right down to the auto-incrementing ID field, and presumably to the
contents of blob offsets in the blob fields.  I then use DBSys to delete one
of the duplicate records, and this corrupts the table.  On accessing the
original record, I get and error # 8963 BLOB block buffers corrupt in the
table 'Assignment'.  If I then repair the table, the contents of all the
blob fields in the record are gone.  Presumably, deleting the second record
wiped out the blobs that the first record was referring to. >>

It's probably this bug:

http://www.elevatesoft.com/scripts/incident.dll?action=viewrep&release=4.22&type=f&incident=2173

--
Tim Young
Elevate Software
www.elevatesoft.com

No, it's not that one.

- I'm not editing the blob fields when this happens
- It happens every time
- My app really does create two Siamese twin records
- Deleting either record corrupts the other's blob fields

--Bill Sparrow--

Bill,

<< No, it's not that one.

- I'm not editing the blob fields when this happens
- It happens every time
- My app really does create two Siamese twin records
- Deleting either record corrupts the other's blob fields >>

In that case, please send me an example and I'll take a look.

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

I'll put one together when I get a few minutes.

Cheers,

--Bill Sparrow--

Bill,

<< I'll put one together when I get a few minutes. >>

Thanks very much.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

I have sent you an example by email.  Will it bounce?  I believe I have
not emailed you with an attachment before, so I won't be on your white
list.

Cheers,

--Bill Sparrow--

It bounced.

--Bill Sparrow--


> A message that you sent could not be delivered to one or more of its
> recipients. This is a permanent error. The following address(es) failed:
>
>  timyoung@elevatesoft.com
>    SMTP error from remote mail server after end of data:
>    host mail.elevatesoft.com [64.65.248.118]: 554 Transaction failed -
>invalid message headers

Bill,

<< I have sent you an example by email.  Will it bounce?  I believe I have
not emailed you with an attachment before, so I won't be on your white list.
>>

It's not the white list, it's that the email headers don't match the sending
information - your sending from cix.uk according to your email header, but
the sending mail server identifies itself as:

Bill,

Sorry, posted that too soon.

It identifies itself as:

lon-gs2dmrelay.mistral.net

and the domains don't match.  We only accept emails directly from a sending
mail server with the same root domain as the sender in the email header.

At any rate, if you could please post it to the Binaries newsgroup, that
will work fine also.

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com