SQLite and Livecode

[Fanfanix]

I am writing an app with Livecode. I select SQLite as a DB and RazorSQL as an editor. After I create the database and one table on RazorSQL, my app can not see that the database has a table. I got the error :No such table exists. I want to know if I do need RazorSQL to create a SQLite DB. The database I created with RazorSQL as a filetype "Document". I find this very strange. What needs to be done in RazorSQL to make the app recognize the SQLite database? Thanks in advance.

[SparkOut]

How are you opening the database in Livecode? You have to use revOpenDatabase("sqlite","/user/Desktop/database.db", , , ) to get a database ID which you can then use to direct queries correctly. What is the syntax you have been using?