If have problems updating contents of a tmemofield to
a Oracle DB in my 3-tier application:

VARCHAR2 fields > 255 chars are handled by the BDE as TMEMO's,
In Delphi these are TMemoFields

When updating a record in my Clientdataset contents of
a TMemoField will be cleared after a update to the DB when:
1 or more of the other fields of the record does change
but the contents of the memofield itself stays equal

This error does not occur for TStringfield, TIntegerfield

I use D3.02, BDE  5.01 ( SQLORA8.dll), ORA804.dll
(I had the same problems using BDE  4.51 ( SQLORA32.dll) )

and use code like:

with  aClientDataSet do
begin
    Filter := ....        // filter one record
    Filtered := true;
    if RecordCount = 1 then
    begin
       First;
       Edit;
       FieldByName('TYPE').AsInteger := k.Type;        //TIntegerField
       FieldByName('NAME').AsString := k.Name;         // TStringfield
       FieldByName('REMARKS').AsString := k.Remarks;   // TMemoField
       Post;
    end
end;

The 'REMARKS'-field gets empty on the occasions described above.

Is this a known BDE/Oracle/SQLlink bug?

Does anybody has a solution other then code like:

 Edit;
 FieldByName('REMARKS').AsString := 'lots of rubbish';
 Post;
 ApplyUpDates(-1);
 Edit;
 FieldByName('TYPE').AsInteger := k.Type;        //TIntegerField
 FieldByName('NAME').AsString := k.Name;         // TStringfield
 FieldByName('REMARKS').AsString := k.Remarks;   // TMemoField
 Post;

which I use as a work around for the moment?

Cheers,

Henk.