Strange issue whilst trying sqlite

Thanks for the reply! I adjusted the query with $this->load->database(); Sadly I received three more errors so I switched to mysql with pdo - no more headaches. I am looking for an extendable way to build a moveable application. But it is my first sqlite3 application and to produce and not have too many issues that might delay delivery I switched over.
Could someone point me to a good instructive tutorial page that explains how to build a sqlite database and connect it to CI3?

Thanks in advance!