The statement has been terminated. String or binary data would be truncate

I am using Delphi 7 , MS 2005 Express, SDAC component and report builder.
Below is the syntax i am using to save a report format to MemoryStream.

var TemplateBlob: TMemoryStream;

  TemplateBlob := TMemoryStream.Create;
  TemplateBlob.LoadFromFile('C:\QuotationRegister.rtm');

  qrBDEInsert.ParamByName('ReportForm').AsString  := 'fmReportQuotation';
  qrBDEInsert.ParamByName('ReportName').AsString  := 'Report1';
  qrBDEInsert.ParamByName('Description').AsString := 'Quotation Report';
  qrBDEInsert.ParamByName('TemplateBlob').LoadFromStream(TemplateBlob,
ftBlob);
  qrBDEInsert.ExecSQL;

  TemplateBlob.Free;

I can Open the report without problems but cannot save the report format to
database.

p/s: The "TemplateBlob" field I am using Binary(1) field,

Replies

• Re: The statement has been terminated. String or binary data would be truncate posted by Tiedo Kruisselbrink on 2 Nov 2007