[odb-users] Raw SQL statement

[Adnan RIHAN]

Hi there,

Long time no see!

Today is the first day I need to do a raw SQL query on Sqlite database. Actually, I simply need to do a “COUNT(*)... WHERE ...”.

I thought about using “result::size” but unfortunately, libodb-sqlite doesn’t support it (according to the doc: http://www.codesynthesis.com/products/odb/doc/manual.xhtml#21.5.1)
So I’m looking for a way to query the database for 1 named column, but I can’t find how (except using views and adding structures).

Is that possible ?
Thank you.
--  
Cordialement, Adnan RIHAN.
Directeur-Gérant de Eolis-Software, société de services informatiques.  

GPG: 5675-62BA (https://keybase.io/max13/key.asc)
-> Si vous n'utilisez pas GPG mais souhaitez quand même m’envoyer un e-mail chiffré: (https://encrypt.to/0x567562BA).