Writing blob file into database by using the sql statement insert into

Question

I am searching at the moment for a possibility in Advantage Database Server via sql to put a byte stream, so called blob file into a table. When I build up a complete database I am doing it like this:

TBlobField(BaseTable.FieldByName('BlobData')).LoadFromStream(BinaryStream);

Now I would like to add an Entry into my database where one Field has the 'BlobData'. I started like that:

FADSQuery.SQL.Add('Insert Into '+DBName'+'(BlobData)');
TBlobField(FADSQuery.ParamByName('BlobData')).LoadFromStream(BinaryStream);

But the compiler tells me it cannot find the BlobData field.:( Is it nearly right to do it like that? I wouldn't like to put inside the insert into statement a whole file by filename.

Thank you in advance

Answer 1

Try something like that:

FADSQuery.SQL.Add('Insert Into '+DBName+'(BlobData) values (:BlobData)');
FADSQuery.ParamByName('BlobData').LoadFromStream(BinaryStream, ftBlob);