How to fill out Database Query Builder fields

[Bill]

Reinhold

Don't give up. I use SQLite3 and it worked great with RunRev and the ALTSQL
plug in. Now I upgraded to 2.7.4 and after moving my datafile (has to be in
the same folder as RunRev main file) and putting the altsqlite plugins where
they go it works fine ....

But, I can't help you with the query builder connection fill-out I find that
even though it works there is no pop-up for SQLite anymore and it is "MYSQL"
that is chosen and which is working even though I'm using SQLite.

In any case I highly recommend that you use Trever's library as much as
possible instead of the query builder as the query builder behaves more like
wine making than science. Trever's library also works faster and you never
get weird errors like the "too many connections open" that you get with the
query builder. The query builder is not really finished anyway as it does
not allow you to insert a new record and the edit record feature doesn't
always work (you enter data in a field and be sure to tab to the next field
and then refresh to check it).

Please try Trevor's library before you give up.

Bill


On 12/4/06 1:11 PM, "Reinhold Venzl-Schubert" <r.venzl-schubert at t-online.de>
wrote:

>> Reinhold,
>> 
>> You should replace the line in your "Database Drivers.txt" file
>> 
>> altSQlite3,dbsqlite3.bundle
>> 
>> with
>> 
>> sqlite3,dbsqlite3.bundle
>> 
>> This combined witht he previous parameters and your test stack
>> works fine on
>> my machine running Rev 2.7.2 on 10.4.9
>> 
>> --
>> cb
> 
> Hi Chris,
> 
> I found 5 files "Database Drivers.txt" in the "2.7.4-gm-1"-Folder:
> 
> 1.  /2.7.4-gm-1/Externals/Database Drivers/Database Drivers.txt
> MySQL,dbmysql.bundle
> ODBC,dbodbc.bundle
> Oracle,dboracle.bundle
> PostgreSQL,dbpostgresql.bundle
> Valentina,VXCMD_macho.bundle
> altSQLite3,dbsqlite3.bundle    <-- this I changed!
> 
> 2.  /2.7.4-gm-1/Runtime/Windows/x86-32/Externals/Database Drivers/
> Database Drivers.txt
> MySQL,dbmysql.dll
> ODBC,dbodbc.dll
> Oracle,dboracle.dll
> PostgreSQL,dbpostgresql.dll
> Valentina,dbvalentina.dll,VXCMD.dll
> 
> 3.  /2.7.4-gm-1/Runtime/Mac OS/PowerPC-32/Externals/Database Drivers/
> Database Drivers.txt
> MySQL,dbmysql.bundle
> ODBC,dbodbc.bundle
> Oracle,dboracle.bundle
> PostgreSQL,dbpostgresql.bundle
> Valentina,VXCMD_macho.bundle
> altSQLite3,dbsqlite3.bundle    <-- this I changed!
> 
> 4.  /2.7.4-gm-1/Runtime/Mac OS/Universal/Externals/Database Drivers/
> Database Drivers.txt
> MySQL,dbmysql.bundle
> ODBC,dbodbc.bundle
> Oracle,dboracle.bundle
> PostgreSQL,dbpostgresql.bundle
> Valentina,VXCMD_macho.bundle
> 
> 5.  /2.7.4-gm-1/Runtime/Mac OS/x86-32/External/Database Drivers/
> Database Drivers.txt
> MySQL,dbmysql.bundle
> ODBC,dbodbc.bundle
> PostgreSQL,dbpostgresql.bundle
> 
> Then I tried it again, but invain! I get the same error message.
> I am so frustrated and tired.
> 
> I bought Revolution 2.7.1 and altSQLite3 to use a database but the
> QueryBuilder of rev 2.7.1 and 2.7.2 did not support altSQLite3.
> The I read, that rev 2.7.4 supports altSQLite3 and I bought rev 2.7.4
> and the Universal Binary Version of altSQLite3.
> 
> It waste my money and my time.
> 
> Reinhold
> 
> 
> _______________________________________________
> 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
 ^^^^^ ^^^^^^^^^^^^^^^^^^^^^
  ^^^^      ^^^^     ^^^    ^^
       ^^^^      ^^^

24 hour cell: (787) 378-6190
fax: (787) 809-8426

Blue Water Maritime
P.O. Box 2087
Rio Grande, PR 00745