[sqlite] Unicode collation sequences for Kexi - the solution

Hi again, Unicode collation sequences for default Kexi (SQLite databases) is what defines _distinction_ between 1. ease of use and ease of deployment desktop db solutions and 2. complexity of server solutions (powerfull but tuned by hand, fragile to changes). I invested into a small research

Re: [sqlite] querying with BLOB in WHERE clause, possible?

On 12/17/2011 09:02 PM, Igor Tandetnik wrote: Using the Android API, I'd like to do something like SELECT * from my_table WHERE my_blob=? My problem is, all of the query methods only take strings as a parameter for the '?' placeholder. How am I supposed to pass in a byte array?

[sqlite] using sqlite calculated field

this query fail: Because I am trying to use the IPPD calculated field. How can i do this? Thanks SELECT datsiniestros.grupo, datsiniestros.siniestro, datsiniestros.ibm, datsiniestros.edad, datsiniestros.porinc, datsiniestros.sexofem, (CASE sexofem WHEN 'False' THEN

Re: [sqlite] using sqlite calculated field

this solution works, but it is very messy: SELECT datsiniestros.grupo, datsiniestros.siniestro, datsiniestros.ibm, datsiniestros.edad, datsiniestros.porinc, datsiniestros.sexofem, /* (CASE sexofem WHEN 'False' THEN parrentas.masc_ippd ELSE parrentas.fem_ippd END) AS IPPD,

[sqlite] primary key and rowid

//First way create primary key: CREATE TABLE t(x INTEGER PRIMARY KEY AUTOINCREMENT, y, z); x being an alias for the rowid? //Second way create primary key: CREATE TABLE t(x INTEGER, y, z, PRIMARY KEY(x AUTOINCREMENT)); x being an alias for the rowid?