Re: How to fill out Database Query Builder fields
Start with reading the PDF. On 12/8/06 5:10 PM, "Reinhold Venzl-Schubert" <[EMAIL PROTECTED]> wrote: > Hi Bill, > > thank you for your consolation. I switched off Revolution for 3 days > and than I swore never to use any QueryBuilder in my life. > > Ok, I will use Trevors library, but how I have to put it? > > I found of a Change Log.txt, > a folder docs with the files > "bmm-cod.css", > "Getting Started with libDatabase.pdf" and > "libDatabase.html" > and the file libDatabase.rev > > Reinhold > > > Am 05.12.2006 um 13:25 schrieb [EMAIL PROTECTED]: > >> 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. > > ___ > use-revolution mailing list > use-revolution@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 ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: How to fill out Database Query Builder fields
Hi Bill, thank you for your consolation. I switched off Revolution for 3 days and than I swore never to use any QueryBuilder in my life. Ok, I will use Trevors library, but how I have to put it? I found of a Change Log.txt, a folder docs with the files "bmm-cod.css", "Getting Started with libDatabase.pdf" and "libDatabase.html" and the file libDatabase.rev Reinhold Am 05.12.2006 um 13:25 schrieb [EMAIL PROTECTED]: 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. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: How to fill out Database Query Builder fields
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" <[EMAIL PROTECTED]> 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@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 ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: How to fill out Database Query Builder fields
Reinhold, Between 2.7.1 and 2.7.2 Runrev changed the configuration for revdb. As far as I know altSqlite and QueryBuilder have always worked when configured as necessary. Support for altSqlite, altBrowser and altFont have officially become part of Runrev as of Dec. 1st. They can be reached at support(at)runrev.com. I'd be happy to help you work through your configuration issues if you contact me off-list at chris(at)altuit.com -- cb On 12/4/06, Reinhold Venzl-Schubert <[EMAIL PROTECTED]> 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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: How to fill out Database Query Builder fields
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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: How to fill out Database Query Builder fields
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 On 12/3/06, Reinhold Venzl-Schubert <[EMAIL PROTECTED]> wrote: Hi Sarah, "altSQLite3" is the select of the QueryBuilder and The name "sqlite3" is necessary to connect to the Database. It is the script used in the SQlite3 Demo of Altuit. Reinhold >> This script connects my stack to my database: >> >> put revdb_connect("sqlite3","TestDB.db","[EMAIL PROTECTED] >> 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: [EMAIL PROTECTED] >> Password: ...xyz... >> > > In one part you use "sqlite3" and in another you use "altSQLite3" as > the database type. I would see if changing this helps. > > Cheers, > Sarah ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: How to fill out Database Query Builder fields
Hi Sarah, "altSQLite3" is the select of the QueryBuilder and The name "sqlite3" is necessary to connect to the Database. It is the script used in the SQlite3 Demo of Altuit. Reinhold This script connects my stack to my database: put revdb_connect("sqlite3","TestDB.db","[EMAIL PROTECTED] 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: [EMAIL PROTECTED] Password: ...xyz... In one part you use "sqlite3" and in another you use "altSQLite3" as the database type. I would see if changing this helps. Cheers, Sarah ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: How to fill out Database Query Builder fields
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: [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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","[EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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? ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: How to fill out Database Query Builder fields
Reinhold, The equivalent querybuilder parameters for your given connect string would be: Name: Fragen Type: altSQLite3 Host: TestDB.db Port:Database: TestDB.db User: [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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","[EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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? Thanks Reinhold___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: How to fill out Database Query Builder fields
This script connects my stack to my database: put revdb_connect("sqlite3","TestDB.db","[EMAIL PROTECTED] 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: [EMAIL PROTECTED] Password: ...xyz... In one part you use "sqlite3" and in another you use "altSQLite3" as the database type. I would see if changing this helps. Cheers, Sarah ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
How to fill out Database Query Builder fields
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","[EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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? Thanks Reinhold___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution