Search found 6 matches

by dontotore
Wed Feb 26, 2014 3:04 pm
Forum: Databases
Topic: Retrieve not encoded data from blob
Replies: 10
Views: 9591

Re: Retrieve not encoded data from blob

WOW!!! IT WORKS!!

Thank you so much!!
by dontotore
Tue Feb 25, 2014 4:57 pm
Forum: Databases
Topic: Retrieve not encoded data from blob
Replies: 10
Views: 9591

Re: Retrieve not encoded data from blob

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.
by dontotore
Fri Jan 10, 2014 12:39 pm
Forum: Databases
Topic: Retrieve not encoded data from blob
Replies: 10
Views: 9591

Re: Retrieve not encoded data from blob

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 SQLQue...
by dontotore
Tue Jan 07, 2014 9:22 pm
Forum: Databases
Topic: Retrieve not encoded data from blob
Replies: 10
Views: 9591

Re: Retrieve not encoded data from blob

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 in a fiel...
by dontotore
Tue Dec 17, 2013 1:31 pm
Forum: Databases
Topic: Retrieve not encoded data from blob
Replies: 10
Views: 9591

Re: Retrieve not encoded data from blob

I forgot to mention thet the Database is SQLite.

No one know how to retrieve binary data from it?
by dontotore
Fri Dec 13, 2013 3:19 pm
Forum: Databases
Topic: Retrieve not encoded data from blob
Replies: 10
Views: 9591

Retrieve not encoded data from blob

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: ×þß Th...