SQLite: check if FTS is enable
Posted: Mon Jul 29, 2013 9:29 am
Just to check if the FTS (Full Text Search) is enable in SQLite or not:
Code: Select all
ImportC "sqlite3.lib"
sqlite3_compileoption_used(str$)
sqlite3_compileoption_get(i)
EndImport
; Display the compiled option
;i = 0
;a = sqlite3_compileoption_get(i)
;While a <> #Null
; Debug PeekS(a)
; i +1
; a = sqlite3_compileoption_get(i)
;Wend
;Debug sqlite3_compileoption_used("SECURE_DELETE") ;SQLITE_
;Debug sqlite3_compileoption_used("ENABLE_FTS3")
;Debug sqlite3_compileoption_used("THREADSAFE")
;Debug sqlite3_compileoption_used("ENABLE_ICU")
If sqlite3_compileoption_used("ENABLE_FTS3") And sqlite3_compileoption_used("ENABLE_FTS3_PARENTHESIS")
Debug "Enhanced Query Syntax enable"
EndIf