Thanks Kay. I reported this as a bug but turns out to be a misunderstanding on the use of revDatabaseColumnNamed.
Courtesy of Mark Waddingham, it turns out that if you are getting binary data from the cursor, you need to use the form of revDatabaseColumnNamed that includes the destination variable in the call, eg: get revDatabaseColumnNamed(tCursor,"BlobColumn","tData") The form "put revDatabaseColumnNamed.... into tData because the transfer into tData stops at the first NULL character. That is mentioned in the dictionary so my bad for not checking first. Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Tue, Nov 11, 2014 at 10:30 PM, Kay C Lan <[email protected]> wrote: > On Wed, Nov 12, 2014 at 9:41 AM, Peter Haworth <[email protected]> wrote: > > > revExecuteSQL gDBID,<Update statement>,"*btData" > > > > Have you tried "tData" without the *b ? > > I thought the *b was the 'old' way of gettting binary data in SQLite. > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
