Database Query Builder

Chris_Wood · Post by **Chris_Wood** » Wed Jan 23, 2008 2:09 am

I am currently using the trial enterprise version of Revolution on
OS X and I am having some problems with the DataBase Query Builder.

In the Connection tab I link to a SQLite database and connect no
problem. However when I go to the Recordset tab there are no tables
listed in the table list.

This problem happens with SQLite databases that are created with a
3rd party tool and also with AppReg3.db created using the SQLite
Sample.rev. Connections and retrieval of records work fine if the
database is accessed by a script.

Has anyone else had this issue and found a solution?

many Thanks

Chris

Lucas_V · Post by **Lucas_V** » Tue Feb 19, 2008 4:47 pm

Same problem here.

This is my first contact with Revolution, and I feel I will have to leave the database query builder as I can't manage to create my database from it's connection ID

Lucas_V · Post by **Lucas_V** » Sat Feb 23, 2008 8:49 pm

Why not bugzilla this ?

Is this bug in the 2.9 beta?

Chris_Wood · Post by **Chris_Wood** » Tue Feb 26, 2008 6:20 am

I sent a message to Run Rev and they said they can't provide support for trial users and suggested writing to the forum.

Looks like it was a bug as Query Builder now works as in 2.9 Beta.

Regards

Chris

Andycal · Post by **Andycal** » Wed Feb 27, 2008 6:34 pm

It nearly works. I actually needed this functionality today so tried my 2.9 beta. It crashes when you add the second field though. Bugzilla raised.