# Problem with reading SQLite virtual table From Clarion 6.3 application **URL:** \ **Category:** questions\ **Tags:** odbc, sqlite, c6\ **Created:** [April 17, 2023, 5:12am UTC](https://clarionhub.com/t/problem-with-reading-sqlite-virtual-table-from-clarion-6-3-application/6153 "2023-04-17T05:12:51Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![sk2107](https://clarionhub.com/user_avatar/clarionhub.com/sk2107/32/3135_2.png) [@sk2107](https://clarionhub.com/u/sk2107)\ **Post date:** [April 17, 2023, 5:12am UTC](https://clarionhub.com/t/problem-with-reading-sqlite-virtual-table-from-clarion-6-3-application/6153/1 "2023-04-17T05:12:52Z")
Greetings, 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 am using Clarion 6.3 and SQLite3 ODBC driver Thank you. ---
**Author:** ![noyantis](https://clarionhub.com/user_avatar/clarionhub.com/noyantis/32/922_2.png) [@noyantis](https://clarionhub.com/u/noyantis)\ **Post date:** [April 17, 2023, 5:39am UTC](https://clarionhub.com/t/problem-with-reading-sqlite-virtual-table-from-clarion-6-3-application/6153/2 "2023-04-17T05:39:23Z")
Hi, John covered part of this during last Wednesday’s Open Webinar (not the c6 usage, but the fts5) - it’s available via the Clarion Live youtube channel. Hope it helps, Regards, Andy [noyantis.com](http://noyantis.com) ---
**Author:** ![sk2107](https://clarionhub.com/user_avatar/clarionhub.com/sk2107/32/3135_2.png) [@sk2107](https://clarionhub.com/u/sk2107)\ **Post date:** [April 17, 2023, 6:07am UTC](https://clarionhub.com/t/problem-with-reading-sqlite-virtual-table-from-clarion-6-3-application/6153/3 "2023-04-17T06:07:30Z")
I will check it thank you ---
**Author:** ![sk2107](https://clarionhub.com/user_avatar/clarionhub.com/sk2107/32/3135_2.png) [@sk2107](https://clarionhub.com/u/sk2107)\ **Post date:** [April 17, 2023, 6:35am UTC](https://clarionhub.com/t/problem-with-reading-sqlite-virtual-table-from-clarion-6-3-application/6153/4 "2023-04-17T06:35:17Z")
I checked that live and it was nice. The problem is that in clarion 6.3 SQLite was not included in the supported databases yet, so I had to use ODBC. Regards ---
**Author:** ![sk2107](https://clarionhub.com/user_avatar/clarionhub.com/sk2107/32/3135_2.png) [@sk2107](https://clarionhub.com/u/sk2107)\ **Post date:** [April 17, 2023, 3:26pm UTC](https://clarionhub.com/t/problem-with-reading-sqlite-virtual-table-from-clarion-6-3-application/6153/5 "2023-04-17T15:26:40Z")
Hi, Still searching but no luck. Any Ideas? Regards ---
**Author:** ![jslarve](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/e480ec/32.png) [@jslarve](https://clarionhub.com/u/jslarve)\ **Post date:** [April 17, 2023, 4:30pm UTC](https://clarionhub.com/t/problem-with-reading-sqlite-virtual-table-from-clarion-6-3-application/6153/6 "2023-04-17T16:30:32Z")
The sqlite3.dll in my demo repo has FTS5 compiled in. I think I just got that from the latest release at the time. I didn’t do anything to add FTS5. ![image](https://clarionhub-uploads.s3.eu-north-1.amazonaws.com/original/2X/2/2d091333c9b7308d74c8122af8c4c1e928b2aa99.png) > **[GitHub - jslarve/SQLiteDriverDemo: Sample Application for using Clarion's SQLite...](https://github.com/jslarve/SQLiteDriverDemo)** > > Sample Application for using Clarion's SQLite Driver for in-Memory Tables ---
**Author:** ![sk2107](https://clarionhub.com/user_avatar/clarionhub.com/sk2107/32/3135_2.png) [@sk2107](https://clarionhub.com/u/sk2107)\ **Post date:** [April 17, 2023, 5:09pm UTC](https://clarionhub.com/t/problem-with-reading-sqlite-virtual-table-from-clarion-6-3-application/6153/7 "2023-04-17T17:09:59Z")
Thank you for your reply. 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. Regards ---
**Author:** ![jslarve](https://clarionhub.com/letter_avatar_proxy/v4/letter/j/e480ec/32.png) [@jslarve](https://clarionhub.com/u/jslarve)\ **Post date:** [April 17, 2023, 6:01pm UTC](https://clarionhub.com/t/problem-with-reading-sqlite-virtual-table-from-clarion-6-3-application/6153/8 "2023-04-17T18:01:46Z")
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. ---
**Author:** ![John\_Hickey](https://clarionhub.com/user_avatar/clarionhub.com/john_hickey/32/445_2.png) [@John\_Hickey](https://clarionhub.com/u/John_Hickey)\ **Post date:** [April 19, 2023, 10:44pm UTC](https://clarionhub.com/t/problem-with-reading-sqlite-virtual-table-from-clarion-6-3-application/6153/9 "2023-04-19T22:44:04Z")
Try using the sqlite odbc dll found at [SQLite-ICU-MinGW/bin-SQLiteODBC-Win-x32x64 at master · pchemguy/SQLite-ICU-MinGW · GitHub](https://github.com/pchemguy/SQLite-ICU-MinGW/tree/master/bin-SQLiteODBC-Win-x32x64) It has the FTS5 module included and active. ---
**Author:** ![sk2107](https://clarionhub.com/user_avatar/clarionhub.com/sk2107/32/3135_2.png) [@sk2107](https://clarionhub.com/u/sk2107)\ **Post date:** [April 20, 2023, 5:21am UTC](https://clarionhub.com/t/problem-with-reading-sqlite-virtual-table-from-clarion-6-3-application/6153/10 "2023-04-20T05:21:29Z")
Thank you. I will check that soon. Regards ---
**Author:** ![sk2107](https://clarionhub.com/user_avatar/clarionhub.com/sk2107/32/3135_2.png) [@sk2107](https://clarionhub.com/u/sk2107)\ **Post date:** [April 20, 2023, 7:09am UTC](https://clarionhub.com/t/problem-with-reading-sqlite-virtual-table-from-clarion-6-3-application/6153/11 "2023-04-20T07:09:08Z")
It is working fine. Thanks a lot. Best Regards