Search found 1 match

by GrantKBrown
Wed 16 Mar 2022 23:31
Forum: InterBase Data Access Components
Topic: How do I save blob data using a stored procedure
Replies: 1
Views: 8156

How do I save blob data using a stored procedure

Hi,
how do I save a memo text into a blob column in my data table

Im using Delphi 10.4 & Firebird

This is the procedure I have in my project Data-module but I can not get it to work

Thanks in advance - Grant

procedure TDataModule2.SaveMasterCompanyData(Sender: TObject; MasterCompany: ptrCompanyData);
begin
try
Save_Master_Company.PrepareSQL;
Save_Master_Company.ParamByName('COMPANY_NAME').AsString := MasterCompany.CompanyName;

Save_Master_Company.ParamByName('COMMENTS').AsMemo := MasterCompany.Comments_Data.Text;
Save_Master_Company.Execute; // executes the stored procedure
finally
Save_Master_Company.Close;
end;
end;