View Incident Report

Serious

Reported By: Kunikazu Okada
Reported On: 8/13/2004
For: Version 4.10 Build 1

# 1810 BLOB Parameter Causes Parse Error in SQL INSERT or UPDATE Statements

Cannot INSERT to Blob field with SQL INSERT and Blob Parameter.

Error Message is as follows:

DBISAM Engine Erro # 11949 SQL parsing error - Expected NULL expression but instead found ? in INSERT SQL statement at line 3, column 13

Create a table with Key:integer and Value: BLOB.

procedure TForm1.Button2Click(Sender: TObject);
begin
  with DBISAMQuery1 do begin

    //insert into T_Test
    //values
    //(10, :BigData)

    Params.ParamByName('BigData').AsBlob := Memo2.Lines.Text;
    ExecSQL;
  end;
end;

(No problem when Value is a MEMO Field.)

Comments

This is also an issue for INSERT..SELECT statements and BLOB fields.

Resolution

Fixed Problem on 8/13/2004 in version 4.11 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap