[yunqa.de] Re: Full text index and search in DISQLITE3
- From: Delphi Inspiration <delphi@xxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Mon, 10 Mar 2008 18:36:26 +0100
Edwin Yip wrote:
>Tried running the demo program under Demos\DISQLite3_Full_Text_Search, when I
>clicked the Add to Index button, an error message showed:
>
>SQLite Error 1 - no such table: FTS.
Opps, the SQL statement which checks if the Full Text Search table already
exists is unfortunately wrong. Please change
DISQLite3_Full_Text_Search_Form_Main.pas as marked here:
{ Test if tables exist already. CREATE VIRTUAL TABLE does not yet support
the IF NOT EXISTS option. }
if (sqlite3_get_boolean(FDb.Handle,
'SELECT 1 FROM sqlite_master WHERE ' +
// ^
'type=''table'' AND name=''' + FTS_TABLE + '''', b) = SQLITE_OK) and
// ^^^^^^
>As the above problem I could go further, so I want to ask some more questions
>before I can make the purchase decision:
>1. If I want to index binary files like MS Word doc, do I have to create the
>plain-text copies for the bin files to index them?
Yes. DISQLite3 does not contain any document converters so you have to provide
them yourself. I believe there are some 3rd party converters (including MS DLLs
for office documents), but have not worked with any of them.
>2. DISQLITE3 is derived from SQLITE3, dose DISQLITE3 keep updated with the
>most latest updates in SQLITE.ORG? I see frequent changes has been making in
>sqlite.org.
Yes, please see the DISQLite3 version history for details:
http://www.yunqa.de/delphi/doku.php/products/sqlite3/history
>3. Are the DB structures same between DI and SQLITE3? If not, I've been using
>SQLITE3 DB, how can I migrate the data to the DISQLITE3 DB?
Yes, with only one exception: The commercial SQLite Encryption Extension
(selling for US$ 2000) is not compatible to the AES encryption of DISQLite3.
Otherwise you can freely share database files between DISQLite3 and SQLite,
including different Operating Systems like Win32 and Linux.
Ralf
_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa
Other related posts:
