Revolution cannot find SQL Lite tables

Sooty57 · Post by **Sooty57** » Wed Sep 05, 2007 2:19 am

I have just purchased Revolution Studio 2.8.1 and am really struggling.

I have some applications I wrote in PHP that use a MySQL database, and I wish to convert these to standalone apps. To make life easier for the end user I was intending to change over to SQL Lite and embed it in the installation.

I have created a database with just one table to experiment with. The table and it's data are there because I can see them with SQL Lite Admin, but the Revolution Query Builder connectes to the database but cannot see any tables.

Anyone got any ideas what may be wrong please?

Mark · Post by **Mark** » Wed Sep 05, 2007 9:06 am

Dear Sooty57,

Could you please post the relevant part of your script?

Best,

Mark

Sooty57 · Post by **Sooty57** » Wed Sep 05, 2007 10:09 am

There is no script to post. The query builder itself connects to the database but cannot find the table, so I never even get as far as creating a query.

I am using SQL Lite 3.0 and have just read that it is incompatible with 2.8. Does Revolution Studio support SQL Lite 3.0?

Mark · Post by **Mark** » Wed Sep 05, 2007 10:33 am

Hi Sooty57,

Before I can answer your question, do you have the SQLite external installed with Revolution? I am not sure whether it was included with Rev 2.8 already. If not, you can find it here:

http://www.runrev.com/offers/plugins.php

or download the latest version of Revolution and dig out the external (revdb.bundle and sqlitedb.bundle).

You don't need to install SQLite 3.0 to use this external.

Best,

Mark

Janschenkel · Post by **Janschenkel** » Wed Sep 05, 2007 11:48 am

Hi Sooty57,

If you know the table names, you can easily write the SELECT query yourself. All the combobox does, is put "SELECT * FROM <selected table name>" into the field below.
Hopefully, the next revision of the database layer will improve support for fetching database schema metadata.

Hope this helped,

Jan Schenkel

edgore · Post by **edgore** » Fri Dec 26, 2008 8:04 pm

It looks like I am having a similar problem, only I am working with an Oracle database through ODBC. The query buidler conencts to the dataase just fine but the list of tables never populates. I can do a "put revDatabaseTableNames(1)" in the message box and after a moment I get back a list of all the tables (about 12 seconds later) and there are about 1440 tables, so I am wondering if I am just overloading he built in table-getter