How to fill out Database Query Builder fields

Reinhold Venzl-Schubert r.venzl-schubert at t-online.de
Sun Dec 3 15:15:16 EST 2006


Chris,

I changed as you suggested but invain.
If you want to see my stack and my Database you find it here:

http://venzl-schubert.macbay.de/Query-Test/QueryBuilderTest.zip

On my computer the Database is in the same folder as Revolution!

Maybe you can find the error.

Reinhold


> The equivalent querybuilder parameters for your given connect  
> string would
> be:
>
> Name:           Fragen
> Type:           altSQLite3
> Host:          TestDB.db
> Port:Database:       TestDB.db
> User:           schubert at t-online.de
> Password:       ...xyz...
>
> I haven't seen any problems running querybuilder on the UB  
> version.  Does
> everything work correctly if you script the database commands with  
> revdb?
>
> --
> cb
>
>
> On 12/2/06, Reinhold Venzl-Schubert <R.Venzl-Schubert at t-online.de>  
> wrote:
>
>>
>> Hi!
>>
>> I need some help in filling out the Database Query Builder correctly.
>>
>> This script connects my stack to my database:
>>
>> put revdb_connect("sqlite3","TestDB.db",,,,,"schubert at t-
>> online.de","...xyz...") into tConID
>>
>> Therefore I filled out in that way:
>>
>> Name:           Fragen
>> Type:           altSQLite3
>> Host:           /Users/rvs/Documents/5-Fächer-Lernprogramm/5FLK- 
>> Rev SLQ
>> Port:
>> Database:       TestDB
>> User:           schubert at t.online.de
>> Password:       ...xyz...
>>
>> When I try  to connect I get this error message:
>>
>> There was an error in connecting to the
>> database. Please check that the connection
>> fields are correct.
>> Revdb error: revdberr, invalid database type
>>
>> Where is the mistake?
>>
>> I got this message before I updated altSQLite3 to the Universal
>> Binary Version (for IntelMac)
>> May it be that the QueryBuilder do not work with the UB Version?
>



More information about the Use-livecode mailing list