Error 104 in FB when using a Blob Field

[skippy]

Hi,

I can't get a file saved in a blob field in a Firebird Database, here's the relevant code snippet:

// tblBinFILE is a TBlobField
// fn is a valid file name with complete path.

tblBin.Append;
tblBinFILENAME.AsString := fn;
tblBinTASK.AsInteger := id;
tblBinFILE.LoadFromFile(fn);
tblBin.Post;

I always get a

Dynamic SQL Error
SQL Error Code = -104
Token unknown - line 2, column 14
FILE.

I don't have any clue what's wrong

Can anybody help ?

TIA

[malinsky]

Hi,

I use:

TBlobField(qTemplates.FieldByName('XLS')).LoadFromFile(FileName);

('XLS' = blob field).

PMal

[skippy]

...which is pretty much the same, isn't it ?

[Falcon]

Set the TUniQuery.Options.QuoteNames property to True or change the field name from "File" to some other name please, because "file" is a reserved word in Interbase/Firebird.

[skippy]

Thanks, works fine !!!