SQLite3 - problems connecting to database

william humphrey shoreagent at gmail.com
Thu Nov 8 13:29:44 EST 2007


Hi Lynn
I wish someone had answered your question. I can't find, anymore, the place
on the RunRev website where they show the new password and user name you're
supposed to use in the database query builder when connecting to the newly
integrated SQLite. Presently I can't even get the query builder to say it is
connected no matter what I try.

Bill

On 10/21/07, Lynn Marie Peterson <lynnp333 at aol.com> wrote:
>
>
> Hi folks ~
>
> Has anyone else had trouble connecting to an SQLite3 database now that
> it's
> integrated into the current Rev v2.8.1 gm-3?
>
> I have no problems connecting and interacting with mySQL databases using
> either the Rev Database Query Builder or the Rev commands themselves.  It
> "appears" as though Rev connects to an SQLite3 database as the Database
> Query Builder says it's connected after clicking on the Connect button,
> however there is no returned database ID and when I change to the Record
> Set
> in QB, the popup menu to the tables says the table(s) are not available.
> It
> says it is connected, even if the full path to the database is not filled
> out, so I suspect it's not connected at all.
>
> If I force type in the name of a table, I get the Rev error message:
> An error resulted for the SQL command in the database: employeeInfo
> Revdb error: Database Error: SQL error or missing database
> Query: SELECT * FROM employeeRecords
>
> I've used both Terminal and the open source app SQLite3 Database Browser
> v1.3  to create a simple SQLite3 database, but am having no luck. I'd
> really
> like to use SQLite3 for apps that only need single user data
> storage/access
> that travel with the app.
>
> Is there something I'm missing?
> Thanks to any and all that can end this frustration.
>
> Lynn Peterson
> OS X 10.4.10 [non Intel]
> Rev Studio v2.8.1 gm-3
> --
> View this message in context:
> http://www.nabble.com/SQLite3---problems-connecting-to-database-tf4667167.html#a13332359
> Sent from the Revolution - User mailing list archive at Nabble.com.
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



-- 
http://www.bluewatermaritime.com



More information about the Use-livecode mailing list