First I used SQLite3 ODBC driver to connect my application to an SQLite table and it was perfect using direct browsing (adding the table to the dictionary) or directly with prop:sql.
But when I tried to read the virtual table in the same DB, I am getting this error: no such module: fts5
after doing some research I found that SQLite FTS5 Extension should be installed, but I could not find from where to get it.
I think this thing is solved in later clarion versions of clarion but not in 6.3 as SQLite was included in those versions so I had to use ODBC instead.
Not sure whether or not FTS5 can be used via ODBC, but you’d certainly want to use an sqlite dll that has that feature enabled before testing it. Not sure you’d do anything different through ODBC as far as PROP:SQL goes.