Request for sqlite3 SQLGetData() support to get a BLOB
An external Rexx function package to connect to SQL databases
Brought to you by:
rexx
Menu
▾
▴
#4 Request for sqlite3 SQLGetData() support to get a BLOB
Mark suggested I submit this feature request.
I have what I think is the latest sqlite3.dll.
VERSION returns "rexxsql 2.5 15 Oct 2006 WIN32 SQLite3"
This rexxsql does not support the SQLGetData() function with this sqlite3.
I have tried the SQLFetch() function to get the BLOB, but it returns an empty string value.
I presume because the first characters in the BLOB are 0x00s, which may be another
issue.
BLOB support in SQLite3 is implemented in a very different way to other databases. It is very difficult to implement Rexx/SQL SQLGetData() support to use SQLite3 BLOBs.