Page 1 of 1
Revolution cannot find SQL Lite tables
Posted: Wed Sep 05, 2007 2:19 am
by Sooty57
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?
Posted: Wed Sep 05, 2007 9:06 am
by Mark
Dear Sooty57,
Could you please post the relevant part of your script?
Best,
Mark
Posted: Wed Sep 05, 2007 10:09 am
by Sooty57
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?
Posted: Wed Sep 05, 2007 10:33 am
by Mark
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
Posted: Wed Sep 05, 2007 11:48 am
by Janschenkel
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
Posted: Fri Dec 26, 2008 8:04 pm
by edgore
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