Icon View Incident Report

Serious 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);
  with DBISAMQuery1 do begin

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

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

(No problem when Value is a MEMO Field.)

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

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