LiveCode Forums.

WOW!!! IT WORKS!!

Thank you so much!!

Unfortunately there is no solution in livecode, so I'm writing externals giving up on portability.
I really would like to know why the developer have done something like this.

Greetings.

get revQueryDatabase(DbId,tQuery,"*btData")

That is used to SELECT data from a database.

If you try to use it, do you get data in the variable "tData"?

From the dictionary:
The revQueryDatabase function returns a record set ID which designates the record set (database cursor) selected by the ...

Hello, sorry for the late reply.


get revQueryDatabase(DbId,tQuery,"*btData")
is used for insert a blob in the DB, I'm trying to RETRIEVE blob from the sqlite DB so it is not good.

print tData
sorry, is not print, is LOG:
LOG tData
this is a message i've written for write the retrieved data ...

I forgot to mention thet the Database is SQLite.

No one know how to retrieve binary data from it?

Hello,
I need to retrieve some data from a BD that I cannot modify.
The data are stored in a BLOB columns and contains not coded images.
This is the begin pieces of one of the data:

HEX:
FFD8 FFE0 0010 4A46 4946 0001 0201 0060 0060
TEXT:
ÿØÿà..JFIF.....'.'

The data retrieved from livecode is ...