Hello Grant,

> Using D5 and FB 1.5
>
> When I try to save some rich text data to a blob field (text) it seems
> to lose all of the rich text formating.

Firebird doesn't give a rats *ss about what you're putting in (text) blobs.

Make sure that your "rich_text" variable actually holds the data including
rich text format.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com

> How do I overcome this ?
>
> ------ the query that I am using to save the data ------------------
> try
> SaveVenAdd.Transaction.StartTransaction;
> SaveVenAdd.Prepare;
> SaveVenAdd.Params[0].asInteger := Add_ID;
> SaveVenAdd.Params[1].asInteger := Current_Vendor_ID;
> SaveVenAdd.Params[2].asInteger := Vendor_ADD_DT;
> SaveVenAdd.Params[3].asString := TitleText;
> SaveVenAdd.Params[4].asString := Rich_Text;
> SaveVenAdd.ExecQuery;
> T := SaveVenAdd.FieldByName('RESULT_ID').AsInteger;
> SaveVenAdd.Transaction.Commit;
> Add_ID := T;
> Result := 0;
> except
> begin
> SaveVenAdd.Transaction.Rollback;
> Result := Err_Code_Minus_2102;
> end;
> end;