LiveCode Forums.

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.

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?