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

"But the compiler tells me it cannot find the BlobData". Please don't "translate" error messages for us. Always provide the exact error message you're receiving. Even if the error message doesn't tell you much, it might tell allot to someone else. — Cosmin Prund
– Cosmin Prund, Commented Jan 24, 2012 at 11:57

da-soft · Accepted Answer · 2012-01-24 14:18:25Z

15

Try something like that:

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

edited Jan 24, 2012 at 14:18

answered Jan 24, 2012 at 11:54

da-soft

7,77031 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Cosmin Prund Over a year ago

+1 for suggesting a syntax for the named parameter and for spotting the wrongly cast to TBlobField.

André Dziurla Over a year ago

Thank you very much for that fast answer. It helped me a lot. And works by including the blobtype : FADSQuery.ParamByName('BlobData').LoadFromStream(BinaryStream,ftBlob);

Fabricio Araujo Over a year ago

@AndréDziurla: if it solves the problem, would be nice to mark this answer as "Accepted".

Ken White Over a year ago

+1. I'd suggest just using FADSQuery.SQL.Text instead, though, since the INSERT is probably the only statement and you won't have to worry about clearing the previous SQL first.

Collectives™ on Stack Overflow

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

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related