Re: [sqlite] requesting 2 tables about one select

Now i am feeling stupid. I tried it many times and it didn't work. Today i tried it again and the code works. Thank you Martin, my problem is solved > Hi, > > this requires a simple join: > > select siterate.name, sitetype.name > from siterate > join sitetype on sitetype.id = siterate.type >

Re: [sqlite] Using incremental BLOB I/O when processing result set

Mark Hessling wrote: > Before I try and implement SQLGetData using the incremental BLOB I/O I > need to know if the approach I am taking is possible. > The major issue is with the API function sqlite3_blob_open(). It > requires: > const char *zDb - according to documentation this could be set to

[sqlite] Using incremental BLOB I/O when processing result set

I have supported a generic Rexx interface to several SQL databases over the last 10 years, including SQLite, Oracle, ODBC, etc. The Rexx API is loosely based on ODBC function calls. I'm now trying to support BLOBs in SQLite. I've read the API for incremental I/O for BLOBs, and also checked the

Re: [sqlite] sqlite3-rdiff: master-slave replication for SQLite

Hello! See new version in fossil repository: http://sqlite.mobigroup.ru/src/wiki?name=sqlite3-rdiff Changes: - parameter --rows-per-hash for building small signatures - analyze command for optimal --rows-per-hash value calculation - parameter --multimaster for limited multimaster support