[Implemented] expose SQLite Blob and data feautes

Got an idea for enhancing PureBasic? New command(s) you'd like to see?
User avatar
pdwyer
Addict
Addict
Posts: 2813
Joined: Tue May 08, 2007 1:27 pm
Location: Chiba, Japan

[Implemented] expose SQLite Blob and data feautes

Post by pdwyer »

PB team,

Some time in the future if you have time, could you implement a way to bind and select blob data in SQLite.

I guess in the spirit of having ReadData() with files as well as typed reads, something similar with database columes like:

Code: Select all

*Data = GetDatabaseData(#Database, Column)
This would call sqlite3_column_blob()

and something to call the length of the data in the pointer to call sqlite3_column_bytes() like:

Code: Select all

DataLength = GetColLen(#Database, Column)
I haven't looked into PB's DB engine enough to know if there are bind methods already. SQLite has ways around this in SQL though.

Thanks
Paul Dwyer

“In nature, it’s not the strongest nor the most intelligent who survives. It’s the most adaptable to change” - Charles Darwin
“If you can't explain it to a six-year old you really don't understand it yourself.” - Albert Einstein