[sqlite-dev] problem using sqldiff.exe with fts table

[Gianpaolo Marin]

Hi, i dowload the latest version of sqldiff 3170000 for compare two db with fts4 table. But if i lunch the command

sqldiff.exe --primarykey --vtab "db1.sqlite" "db2.sqlite" > diff.txt

it returns

sqldiff.exe: SQL statement error: no such module: fts4
"PRAGMA main.table_info='v_images'"

I have this error with fts3, fts4 or fts5 table but in this version there is witen in the documentation that the virtual table are supported.

Best regards

---

Gianpaolo Marin - Arcoda s.r.l.  

    tel. +39 0461 1920144 fax +39 0461 1860888 - www.arcoda.it - via del Brennero 139 - 38121 Trento, ITALY

[Bernardino Ramos]

It supports but they must be enabled when compiling. Check this out:

https://www.sqlite.org/fts3.html#compiling_and_enabling_fts3_and_fts4

For more questions like this use the sqlite-users mailing list.

Bernardo Ramos

_______________________________________________
sqlite-dev mailing list
sqlit...@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-dev