Re: Syntax error

Posted by Jiba on
URL: http://owlready.306.s1.nabble.com/Syntax-error-tp774p775.html

Hi,

I think the problem is related to the version of SQLite you are using (or possibly the version of Python, since SQLite is embedded in Python standard distribution). The "CREATE VIEW table (columns)" syntax is rather recent (2015) and Python 3.5 is not the latest version.

In the development version on Mercurial, I replaced it by another equivalent syntax that should be better supported by older version of SQLite. Alternatively, you can also replace line 136 in triplelite.py by the following one:

        self.execute("""CREATE VIEW quads AS SELECT c,s,p,o,NULL AS d FROM objs UNION ALL SELECT c,s,p,o,d FROM datas""")

Could you try and tell me if it works now?

Best regards,
Jiba