Reading BLOB field

[goranpro]

Hello,

I am trying to read blob field into stream but without success. Could you please point me the right way to do it.

This is my code:

TUniQuery *q = new TUniQuery(NULL);
q->Connection = MyConnection;
q->SQL->Text = "select blob_field from mytable";
q->Open();

TStream *st = q->CreateBlobStream((TBlobField *) q->FieldByName("BLOB_FIELD"),bmRead);

******Error: Field is not BLOB!

Thank You

[AlexP]

hello,

We cannot reproduce the problem.
Please specify thе name and the version of the DB you are using, also send a script for creating the table with a BLOB field

[goranpro]

Hello AlexP,

I am so sorry, there was a mistake in my query, two fields where switched.
Now it works.
Thank You again.

[AlexP]

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.