SQLite: check if FTS is enable

Share your advanced PureBasic knowledge/code with the community.
User avatar
flaith
Enthusiast
Enthusiast
Posts: 704
Joined: Mon Apr 25, 2005 9:28 pm
Location: $300:20 58 FC 60 - Rennes
Contact:

SQLite: check if FTS is enable

Post by flaith »

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
“Fear is a reaction. Courage is a decision.” - WC