Page 1 of 1

[Implemented] expose SQLite Blob and data feautes

Posted: Sun Jun 01, 2008 3:11 pm
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