Hi

I use the following code to make a copy of a record:

StandardTable.CopyOnAppend := True;
StandardTable.Insert;
StandardTable.FieldByName('RecordNoNo').AsInteger := 0;
StandardTable.Post;
StandardTable.CopyOnAppend := False;

The Table has Blob and Memo fields, but everytime I get Blob field
corrupted.

What am I doing wrong here?

Thanks

Petrus

Hi

Sorry, but it seems that I have found it.

Thanks

Petrus

"Petrus van Breda" <petrus@spsoftdev.com> wrote in message
news:E61B6927-DD80-4858-B890-0393C3E06CA8@news.elevatesoft.com...
> Hi
>
> I use the following code to make a copy of a record:
>
> StandardTable.CopyOnAppend := True;
> StandardTable.Insert;
> StandardTable.FieldByName('RecordNoNo').AsInteger := 0;
> StandardTable.Post;
> StandardTable.CopyOnAppend := False;
>
> The Table has Blob and Memo fields, but everytime I get Blob field
> corrupted.
>
> What am I doing wrong here?
>
> Thanks
>
> Petrus
>

Petrus,

<< Sorry, but it seems that I have found it. >>

Were you using an older version of DBISAM ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi

When I removed:

StandardTable.FieldByName('RecordNoNo').AsInteger := 0;

All seems to be fine.

I still get a corruption sometimes, but I need look at it, as I use streams
to update the blob file and are thinking that I do something here?

Will first investigate and then let you know if the problem still exists.

Thanks

Petrus

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:146CB3EC-8C2F-4D8A-BE53-56CB9C4124FF@news.elevatesoft.com...
> Petrus,
>
> << Sorry, but it seems that I have found it. >>
>
> Were you using an older version of DBISAM ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Petrus,

<< I still get a corruption sometimes, but I need look at it, as I use
streams to update the blob file and are thinking that I do something here?
>>

There was an issue with an older 4.x version that had to do with updating
BLOB fields that could cause an issue:

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

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

--
Tim Young
Elevate Software
www.elevatesoft.com