[sqlite] Can this be sorted?

Have the following full SQL: SELECT DS.DRUG_NAME AS DRUG_NAME, SUM(INSTR(M.ASSOCIATED_TEXT, DS.SENSITIVE_STRING) > 0) AS SENSITIVE, SUM(INSTR(M.ASSOCIATED_TEXT, DS.RESISTANT_STRING) > 0) AS RESISTANT, ROUND(TOTAL(INSTR(M.ASSOCIATED_TEXT, DS.SENSITIVE_STRING) > 0) / (TOTAL(INSTR(M.ASSOCIATED_TEXT,

[sqlite] Can this be sorted?

On 2/15/2015 6:54 PM, Bart Smissaert wrote: > Result is shown below. > > *Drug**Sensitive* > *Resistant**Ratio*Ertapenem 10201Meropenem301Pip/Tazobactam301 > Cefalexin/Cefdrxl4070.85Gentamicin310.75CiprofloxacinS1570.68Amoxicillin2115 >

[sqlite] System.Data.SQLite and spellfix under VB.net

Hello, could some please post a sample how to use the spellfix module with System.Data.SQLite under VB.net? If i try to create the required table as documented here: http://www.sqlite.org/spellfix1.html I end up with an error: "SQL logic error or missing database no such module: spellfix1"