Database Query Builder
...To start, I'll read the manual, do the tutorials, etc. before I ask additional questions. My printed user manual arrived, and the information I needed is right there at sections 8.5.1 and 8.5.2. I don't know how I missed the first sentence at 8.5.1! Maybe there's something special about reflected light... ___ 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: Database Query Builder
--- Kurt Kaufman [EMAIL PROTECTED] wrote: Is the Database Query Builder designed to be used only within the IDE, or can its functionality be exported into a standalone application (as a sort of core for a stack -- standalone)? Sorry if this is a FAQ; I haven't fully explored this area of Revolution yet. -Kurt Hi Kurt, As the Database Query Builder is jhust another stack, you can take it apart and look at its scripts; while it does have some IDE-specific dependencies, you can learn enough to make your own derivative. What exactly are you trying to accomplish? Jan Schenkel. Quartam Reports PDF Library for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) ___ 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
Database Query Builder
Thanks, Jan. I'm looking into the possibility of redesigning an accounts-receivable program that currently is written entirely in Revolution. I have it designed to allow a limited form of multi-user access, but it's cumbersome, and a switch to a SQL database would leverage that arrangement's natural advantages. To start, I'll read the manual, do the tutorials, etc. before I ask additional questions. thanks again, Kurt ___ 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
Database Query Builder
Is the Database Query Builder designed to be used only within the IDE, or can its functionality be exported into a standalone application (as a sort of core for a stack -- standalone)? Sorry if this is a FAQ; I haven't fully explored this area of Revolution yet. -Kurt ___ 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: GLX2 new feature when working with SQLite databases and database query builder
William, GLX2 set the default folder, but sets it back again. Perhaps this process was interrupted. I'll double check the code to bullet-proof it. Thanks for the report and detective work. Best, Jerry Daniels Daniels Mara, Inc. Makers of GLX2 http://www.daniels-mara.com/glx2 On Mar 22, 2008, at 5:04 PM, william humphrey wrote: Thanks for the explanation. So GLX2 changed my default folder without notifying me. That's interesting. When it happens and the empty database gets created in there it makes RunRev use nearly all the processor cycles and slow to a crawl. If you use the database query builder then the database has to be in the default folder so thanks very much for the suggestion on setting the defaultFolder. ___ 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: GLX2 new feature when working with SQLite databases and database query builder
William, I have just uploaded a new beta to our update server. You and all other licensees can now update to b41. It has several small bug fixes in it, including the restoration of the default folder under any and all circumstances where GLX2 might need to set it. Best, Jerry Daniels Daniels Mara, Inc. Makers of GLX2 http://www.daniels-mara.com/glx2 On Mar 24, 2008, at 10:16 AM, Jerry Daniels wrote: William, GLX2 set the default folder, but sets it back again. Perhaps this process was interrupted. I'll double check the code to bullet-proof it. Thanks for the report and detective work. Best, Jerry Daniels Daniels Mara, Inc. Makers of GLX2 http://www.daniels-mara.com/glx2 On Mar 22, 2008, at 5:04 PM, william humphrey wrote: Thanks for the explanation. So GLX2 changed my default folder without notifying me. That's interesting. When it happens and the empty database gets created in there it makes RunRev use nearly all the processor cycles and slow to a crawl. If you use the database query builder then the database has to be in the default folder so thanks very much for the suggestion on setting the defaultFolder. ___ 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 ___ 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
GLX2 new feature when working with SQLite databases and database query builder
I just changed the subject I just updated to GLX 2.1b40 and it did something (automatically) that I realize now is very cool but which caused me some consternation. It made a GLX2 Work Spaces folder in the My Revolution Studio folder and put an empty copy of my SQLite database there. This caused all kinds of problems since it was an empty copy (maybe it should have notified me with an error message). I had to figure this out and move the database from the location where it had been before (and a not very good location but the only place I could get it to work in the past -- inside the application folder for RunRev). Now all my calls using RunRev's built in Database query manager work fine but none of my manual calls which require registering SQLite with a file path that I have been using but not really liking like so: put /Applications/Revolution_Studio/2.8.1-gm-3/shipping.sqlite into tDBA[FilePath] I'd much rather the file path to SQLite was automatic to a nice folder like GLX2 just did for me. So I'm writing this to warn other users of GLX2 about this new feature and I'm hoping someone that knows this stuff will tell me a better way to say put /Users/administrator/Documents/My\ Revolution\ Studio/Plugins/GLX2\ Work\ Spaces/shipping.sqlite into tDBA[FilePath] for the SQLite stuff I'm doing without using RunRev's built in Database Query Builder. Ideally there would just be a call to whatever GLX2 figured out. Thanks and I think GLX2 is great and if I had more time to spend programming and less time urgently needing to use the program I wrote (badly and unfinished) I'm sure I would like it even more. and thanks as always for helping -- Bill PS - and I wish I could go to the RunRev conference and sit in on Trevor's class! ___ 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: GLX2 new feature when working with SQLite databases and database query builder
On Sun, Mar 23, 2008 at 1:26 AM, william humphrey [EMAIL PROTECTED] wrote: I just changed the subject I just updated to GLX 2.1b40 and it did something (automatically) that I realize now is very cool but which caused me some consternation. It made a GLX2 Work Spaces folder in the My Revolution Studio folder and put an empty copy of my SQLite database there. GLX2 creates that folder, but there is no reason for it to move your database. I expect what happened was that the defaultFolder was changed to this workspaces folder and your database was saved assuming the defaultFolder was the same as before. Looking at the oath your were using before, it appears that you were always using the default folder as the database was being saved in your Revolution application folder. How about when creating and using your database, you specify the path yourself, and put it somewhere more logical e.g. Documents folder, Preferences folder, Application Support folder (I don't know what the database is for, so you will have to decide the location yourself). Try something like this: put specialFolderPath(Documents) /shipping.sqlite into tDBA[FilePath] Or if you want to use the defaultFolder: set the defaultFolder to specialFolderPath(Documents) If you use the defaultFolder method, you need to make sure it is set each time, as any other stack or plugin might have changed it. HTH, 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: GLX2 new feature when working with SQLite databases and database query builder
Can you tell me why specialFolderPath(Documents) has Documents in there? Is it a way to set that type of folder path as opposed to one that is an application for RunRev to use instead of a Document? ___ 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: GLX2 new feature when working with SQLite databases and database query builder
Sarah Ignore that question please. I looked it up. Bill On Sat, Mar 22, 2008 at 6:31 PM, william humphrey [EMAIL PROTECTED] wrote: Can you tell me why specialFolderPath(Documents) has Documents in there? Is it a way to set that type of folder path as opposed to one that is an application for RunRev to use instead of a Document? -- http://www.bluewatermaritime.com ___ 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
Problem building stand alone database application using database query builder
Greetings, Wondering if anyone can shed some light on this problem? Context In the past building database apps I have coded everything, meaning, scripted the database connection, the queries to add, modify, delete, search, etc. They work. Problem This time I'm trying to build a simple app following the example in the database tutorial using the query builder, then selecting the actions from the pull down list and connecting them to buttons. As long as I am running this application in the IDE, it works fine. When I save it as a stand alone exe under Windows, it doesn't work any more (meaning, nothing happens when I press the buttons, it isn't connected to the database). I have made sure that all database stuff is included in the standalone set up. I do receive some error messages but I think they are irrelevant since I am not on a Mac 1MacOS, database driver folder not found: C:/Program Files/Revolution Enterprise/2.7.4-gm-1/Runtime/Mac OS X/Universal/Externals/Database Drivers/dboracle.bundle 2MacOS, database driver folder not found: C:/Program Files/Revolution Enterprise/2.7.4-gm-1/Runtime/Mac OS X/Universal/Externals/Database Drivers/VXCMD_macho.bundle Solution??? Thank you in advance, anyone, for any suggestions. Regards, Sadhu ___ 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
Database Query builder
Holá everybody, Working with RunRev 2.7.4 I have a table objekt which shows me selected adresses from a MySQL Database. #- works fine in a field script I´m using the command: put the selectedtext of me into var1 set itemdel to tab put item 1 of var1 into Cstm_nrr #- which is also correct and works fine But, and that´s the question: How to open a new (existing) Card to show the datas behind the customernumber I think I can´t mix SQL with RunRev variables otherwise I would say in the Database query builder: SELECT * from Customers where customernumber = Cstm_nr Thank you all for a helping hand Horst ___ 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
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
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, 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 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
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
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
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
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
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
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
AltSQLite and Database Query Builder
I am currently using altSQLite3 and trying to see if I can use the Database Query Builder to hook it into. I have a few questions. 1. Once the database has been created, is it best placed in the same folder as the Applications Mainstack? Or in the folder with the Revolution Application? 2. In Database Query Builder, I have the following questions: A)Host: In the tutorial, the writer puts in RunRev. Does this mean that the Host is the Revolution Studio Application? But should I put in localhost? Or name it anything that I want? Or Use the Filepath to the Database file? (not the Application) B) Database Is this only the name of the Database? e.g.. TestDatabase OR should it include the entire FilePath A:\\HardDriveName\Applications\Revolution Studio\Work\TestDatabase Or should it ALWAYS have the extension? e.g. TestDatabase.sqlite Should the extension be .sqlite OR dbsqlite OR altsqlite3 C)User If it is on my local machine, then do I have to put in a User Name? Or is there a default if I am NOT on an external server? Or can I leave it blank to connect? D) Password: If it is on my local machine, then do I have to put in a Passwoord? Or is there a default if I am NOT on an external server? Or can I leave it blank to connect? I also learned from Chris at altuit that in the Altuit tutorial's CONNECTION BUTTON SCRIPT, the revdb_connect command...requires the commas. E.g. AppReg.db, According to Chris, You need the commas. They are extra parameters that revdb uses when connecting to other database(Mysql,Postgres, Oracle and the like)..In altSqlite we don't need them, but they still need to be passed to the function call as empty. A lot of people might already know that but not a Newbie like myself. Thanks, Revolutionary Michael ___ 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: AltSQLite and Database Query Builder
On 6/6/06 12:08 PM, Michael Mandaville [EMAIL PROTECTED] wrote: I am currently using altSQLite3 and trying to see if I can use the Database Query Builder to hook it into. I have a few questions. 1. Once the database has been created, is it best placed in the same folder as the Applications Mainstack? Or in the folder with the Revolution Application? I've always found that the database has to be the same folder as the application (which for recent versions is inside the folder with the version number and gm. 2. In Database Query Builder, I have the following questions: A)Host: In the tutorial, the writer puts in RunRev. Does this mean that the Host is the Revolution Studio Application? But should I put in localhost? Or name it anything that I want? Or Use the Filepath to the Database file? (not the Application) For both host and database put the name of the database. B) Database Is this only the name of the Database? e.g.. TestDatabase OR should it include the entire FilePath A:\\HardDriveName\Applications\Revolution Studio\Work\TestDatabase Or should it ALWAYS have the extension? e.g. TestDatabase.sqlite Should the extension be .sqlite OR dbsqlite OR altsqlite3 I use the extension .db and the extension .sqlite C)User If it is on my local machine, then do I have to put in a User Name? Or is there a default if I am NOT on an external server? Or can I leave it blank to connect? D) Password: If it is on my local machine, then do I have to put in a Passwoord? Or is there a default if I am NOT on an external server? Or can I leave it blank to connect? For sqlite3 you have to put your email and the special password altuit gives you or it will not work I also learned from Chris at altuit that in the Altuit tutorial's CONNECTION BUTTON SCRIPT, the revdb_connect command...requires the commas. E.g. AppReg.db, According to Chris, You need the commas. They are extra parameters that revdb uses when connecting to other database(Mysql,Postgres, Oracle and the like)..In altSqlite we don't need them, but they still need to be passed to the function call as empty. A lot of people might already know that but not a Newbie like myself. Thanks, Revolutionary Michael ___ 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 91 Puerto Real, PR 00740 ___ 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 in the Database Query Builder?
Hi! My trial to build a Database Query to an altSQLite-Database fails, but Revolution stores it somewhere. Because when I save my stack and open it again, I got the same error message and the Database Query Builder shows me the failed Query. Therefore I looked for the place where Revolution stores the failed query. I expected to find a script anywhere and wanted to look at it to find a mistake. But I did not find neither a script nor anything else. I used Analyse it... of 2lz2 from Klaus Major for my search. Where is a Database Query stored in the stack? Reinhold Hi! I just go my first steps in using database with Revolution. I bought a license von SQLite from Altuit and created my first database AppReg3.db Then I created a stack and want to build a database query with the Database Query Builder. I studied the User Guide and the appropriated video but I cannot connect to the db. Whatever I tried I got the message: There was an error in connecting to the database. Please check that the connection fields are correct. Revdb error: revdberr, invalid database type Please give me a little help to fill in correctly: Name:Query 1 Type: altSQLite3 Host: ? Database: ? User:my emailadress that I used to create the AppReg3.db Password: my password that I used to create the AppReg3.db The database is located in the folder /Applications/Revolution Studio/2.7.1-gm-1 The stack is located in the folder /Users/rvs/Documents/My Revolution Studio/Programme - - - - - - - - - - - - - - - The script I created the AppReg3.db is: on mouseUp global gConID put revdb_connect(sqlite3,AppReg3.db,[EMAIL PROTECTED] online.de,XXxxXXxxxXxxXX) into tConID if tConID is then answer warning Problem creating or accessing database! else answer information AppReg Connected! Your connection ID is: tConID put tConID into gConID end if end mouseUp - - - - - - - - - - - - - - - - The script I created the table is: on handleRevDBerror p switch case item 1 of p is revdberr return revDB Error: p break case syntax error is in p return Database Error: p break end switch end handleRevDBerror on mouseUp global gConID if gConID is then answer information No Database is Connected to, please go back 1 step and connect to the Database! exit mouseUp end if put CREATE TABLE Karten_Daten(KarteID integer primary key,Frage text,Antwort text) into tSQL put revdb_execute(gConID,tSQL) into tTmp handleRevDBerror tTmp if the result is not empty then answer warning the result exit mouseUp end if answer information Number of Tables Added: tTmp end mouseUp Thanks Reinhold Venzl-Schubert ___ 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 in the Database Query Builder?
Hi! I just go my first steps in using database with Revolution. I bought a license von SQLite from Altuit and created my first database AppReg3.db Then I created a stack and want to build a database query with the Database Query Builder. I studied the User Guide and the appropriated video but I cannot connect to the db. Whatever I tried I got the message: There was an error in connecting to the database. Please check that the connection fields are correct. Revdb error: revdberr, invalid database type Please give me a little help to fill in correctly: Name:Query 1 Type: altSQLite3 Host: ? Database: ? User:my emailadress that I used to create the AppReg3.db Password: my password that I used to create the AppReg3.db The database is located in the folder /Applications/Revolution Studio/2.7.1-gm-1 The stack is located in the folder /Users/rvs/Documents/My Revolution Studio/Programme - - - - - - - - - - - - - - - The script I created the AppReg3.db is: on mouseUp global gConID put revdb_connect(sqlite3,AppReg3.db,[EMAIL PROTECTED] online.de,XXxxXXxxxXxxXX) into tConID if tConID is then answer warning Problem creating or accessing database! else answer information AppReg Connected! Your connection ID is: tConID put tConID into gConID end if end mouseUp - - - - - - - - - - - - - - - - The script I created the table is: on handleRevDBerror p switch case item 1 of p is revdberr return revDB Error: p break case syntax error is in p return Database Error: p break end switch end handleRevDBerror on mouseUp global gConID if gConID is then answer information No Database is Connected to, please go back 1 step and connect to the Database! exit mouseUp end if put CREATE TABLE Karten_Daten(KarteID integer primary key,Frage text,Antwort text) into tSQL put revdb_execute(gConID,tSQL) into tTmp handleRevDBerror tTmp if the result is not empty then answer warning the result exit mouseUp end if answer information Number of Tables Added: tTmp end mouseUp Thanks Reinhold Venzl-Schubert ___ 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
Database Query Builder
Hi folks, I'm using altSQLLite for the database. One thing I can't seem to get right is the path to the table (it's in the same path as the executable). The Database Query Builder only takes a fixed path for the location of the database. i.e. C:\MyFolder\MyApp\mytable.db Is there a way to overcome this? I've read the doc's - for both the Database Query Builder and altSQL and I seem to be missing something. Note - I've posted this here and not as a direct support request to Altuit because it seems to be more a Rev issue than an alSQL issue - but of course I could be wrong - that's happened before. g Scott ___ 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: Database Query Builder
I use the database query builder a lot but have been gradually shifting over to libDatabase is a database abstraction library by Trevor DeVore which is much better than the database query builder for everything except easily building a card that goes through each record of a database. I highly recommend it especially when working with sqlite. As an example, if you look for a record using the database query builder and it is a record that does not exist then not only will it bring your stack down sometimes you have to reboot the system too. Also if you ever have a database query builder connection to the database in one of your cards or substacks and it stops working it is impossible to track it down (so you will always -- thereafter -- get an error message can't connect to the database even though all the queries that you still use are connected). I put the sqlite database (on mac os x) in the same folder as my runtime revolution application as that was the only place it would work (the stack itself can be anywhere). So I don't have any path in the field that says Database just the name of the database. On 8/27/05 7:36 AM, Scott Kane [EMAIL PROTECTED] wrote: Hi folks, I'm using altSQLLite for the database. One thing I can't seem to get right is the path to the table (it's in the same path as the executable). The Database Query Builder only takes a fixed path for the location of the database. i.e. C:\MyFolder\MyApp\mytable.db Is there a way to overcome this? I've read the doc's - for both the Database Query Builder and altSQL and I seem to be missing something. Note - I've posted this here and not as a direct support request to Altuit because it seems to be more a Rev issue than an alSQL issue - but of course I could be wrong - that's happened before. g Scott ___ 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 91 Puerto Real, PR 00740 ___ 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: Database Query Builder
Hi Bill, Thanks for the info. Has this issue with Query Builder that you mention been raised as a bug with Rev? I'm going to take a look at libDatabase - but will it work with altSQL - because I'm adament to use that library, it's so nicely done. Scott ___ 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: Database Query Builder
On Aug 27, 2005, at 5:03 PM, Scott Kane wrote: Hi Bill, Thanks for the info. Has this issue with Query Builder that you mention been raised as a bug with Rev? I'm going to take a look at libDatabase - but will it work with altSQL - because I'm adament to use that library, it's so nicely done. Version 2 of libDatabase will work with altSQLite. I haven't posted the version 2 library yet but I have it along with docs if you want to take a look. Version 2 is mostly done, I just haven't had time to package it up and update my website. Just email me off list and I can send it to you. In a nutshell libDatabase is just a higher level abstraction library that sits on top of revDB or Valentina and simplifies working with databases. -- Trevor DeVore Blue Mango Multimedia [EMAIL PROTECTED] ___ 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: Database Query Builder
That's a good question. It would be nice if the query builder didn't crash when you search for a record that isn't there. But in order to search for a record with the query builder you have to use revsetSQLofQuery and I believe that isn't a supported command (maybe because it isn't finished) but it is a very necessary one if you want to do functional stuff with the query builder. It's much better to use the libDatabase for most things. On 8/27/05 8:03 PM, Scott Kane [EMAIL PROTECTED] wrote: Thanks for the info. Has this issue with Query Builder that you mention been raised as a bug with Rev? ||| )_) )_) )_) )___))___))___)\ )))_)\\ _|||\\\__ ---\ /- http://www.bluewatermaritime.com ^ ^ ^^^^^ ^^^ 24 hour cell: (787) 378-6190 fax: (787) 809-8426 Blue Water Maritime P.O. Box 91 Puerto Real, PR 00740 ___ 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: Database Query Builder -- errors
--- Bill Humphrey [EMAIL PROTECTED] wrote: In case anyone else wants to use this great thing extensively then when designing your databases always use unique names for every column even when in different tables because if you refer to a column as tablename1.shipID and another one as tablename2.shipID even though SQL is happy with this the database query builder update feature will choke. [Sorry for the late reply, jsut cleaning the backlog] You're touching on one of the main drawbacks of SQL databases: their relational syntax makes it easy to combine data from multiple tables in a meaningful way -- but what if you want to update the data ? In the above example, the shipID field might be the primary key for both tables, and there might be a one-to-one relationship between them. But it is far more likely that it is the primary key for tablename1, but only part of the primary key for tablename2 -- or it could be just a foreign key. This means that while the revDatabse frontscirpt can farily easily update the database when you're displaying data from one table and telling it the primary key of that table ; but updating combined data from multiple tables is a different game entirely ! You would have to provide the primary key for each table involved in the query and may therefore have to add fields in order to have the key columns. Note that this is also the main reason why it is near impossible to provide a 'Create record' functionality in that frontscript: if there's more than one table involved, where should it create new records? In all tables? In some of them? In only one of them? Database solutions like FileMaker Pro have ready access to the full database schema, including the relations between the tables, and may use some heuristics to figure out what it needs to create. But it is very tricky to get this right without inner knowledge of the database structure. Which is why I usually tell people to do the SQL-stuff themselves, and employ the database-linked controls mainly for viewing data and minor editing. You can easily piggy-back on the existing query conection data by using the other calls in the revDatabase frontscript like : -- revExecuteWithQuery query name,sql query -- Hope this helped, Jan Schenkel. Quartam - Tools for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Discover Yahoo! Use Yahoo! to plan a weekend, have fun online and more. Check it out! http://discover.yahoo.com/ ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Database Query Builder -- errors
In case anyone else wants to use this great thing extensively then when designing your databases always use unique names for every column even when in different tables because if you refer to a column as tablename1.shipID and another one as tablename2.shipID even though SQL is happy with this the database query builder update feature will choke. And if you use SQLite which won't allow you to alter tables then you will be in trouble. Also when you have many joins in your query use the index for the fields you are most likely to want to change (this error is not as perfectly repeatable). Should I bugzilla this? ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder -- errors
On Jun 6, 2005, at 6:28 AM, Bill Humphrey wrote: In case anyone else wants to use this great thing extensively then when designing your databases always use unique names for every column even when in different tables because if you refer to a column as tablename1.shipID and another one as tablename2.shipID even though SQL is happy with this the database query builder update feature will choke. You could probably get around this by doing: SELECT tablename1.shipID AS ShipID1, tablename2.shipID AS ShipID2... -- Trevor DeVore Blue Mango Multimedia [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder -- errors
Thank you, thank you. I didn't even think to try alias for the name and I was just checking out how I can make view's in SQLite and then swap those in and out easily. I'll try it now and see. Trevor DeVore wrote: On Jun 6, 2005, at 6:28 AM, Bill Humphrey wrote: In case anyone else wants to use this great thing extensively then when designing your databases always use unique names for every column even when in different tables because if you refer to a column as tablename1.shipID and another one as tablename2.shipID even though SQL is happy with this the database query builder update feature will choke. You could probably get around this by doing: SELECT tablename1.shipID AS ShipID1, tablename2.shipID AS ShipID2... ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder -- errors and aliases
Boy did that crash RunRev fast! I don't even have to worry about changing anything back to the way it was ;) Trevor DeVore wrote: On Jun 6, 2005, at 6:28 AM, Bill Humphrey wrote: In case anyone else wants to use this great thing extensively then when designing your databases always use unique names for every column even when in different tables because if you refer to a column as tablename1.shipID and another one as tablename2.shipID even though SQL is happy with this the database query builder update feature will choke. You could probably get around this by doing: SELECT tablename1.shipID AS ShipID1, tablename2.shipID AS ShipID2... ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder 2
--- [EMAIL PROTECTED] wrote: [snip] So now I can make changes but I still have one major hickup. If I click a button that is linked to the database such as a Next button set to 'Move to Next Record' then the field doesn't appear to ever get the close message needed to trigger the update. If I click any non DQB linked button or in the background then the save is made but if I go straight to a button like Next then the change is lost. I created a workaround by putting the Next button off screen and then making a fake Next button that does this ... click at 1,1 -- where there is nothing click at the loc of btn Next ... but that really slows things down. I suppose i could play with ways to speed things up but here again the DQB is supposed to be helping me knock this thing out quick. Any other half-documented features out there to which i should be paying attetion ?Thanks. Hi Chris, This problem would happen on MacOS, of course -- not on Windows/Unix, as the MacOS HIG is the only one where a button doesn't receive the keyboard focus. You could patch the mouseUp handler in the revDatabase frontscript to get around that limitation, and make sure the closeField is called, as follows : ## just after the line if exists(pObject) and the cREVGeneral[databasequeryobject] of pObject is true then ## you insert the following line select empty ## this causes any open field to receive a closeField You might want to bugzilla this problem, and suggest the patch above. Hope this helped, Jan Schenkel. Quartam - Tools for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder 2
Thank you Jan. I will do that with BZ. I know how to do the sql connect using the functions but I think the DBQ could be such a boon for new users that I really want to see it work. As we say in my country YOU are the man! Jan writes: Hi Chris, This problem would happen on MacOS, of course -- not on Windows/Unix, as the MacOS HIG is the only one where a button doesn't receive the keyboard focus. You could patch the mouseUp handler in the revDatabase frontscript to get around that limitation, and make sure the closeField is called, as follows : ## just after the line if exists(pObject) and the cREVGeneral[databasequeryobject] of pObject is true then ## you insert the following line select empty ## this causes any open field to receive a closeField You might want to bugzilla this problem, and suggest the patch above. --- [EMAIL PROTECTED] wrote: [snip] So now I can make changes but I still have one major hickup. If I click a button that is linked to the database such as a Next button set to 'Move to Next Record' then the field doesn't appear to ever get the close message needed to trigger the update. If I click any non DQB linked button or in the background then the save is made but if I go straight to a button like Next then the change is lost. I created a workaround by putting the Next button off screen and then making a fake Next button that does this ... click at 1,1 -- where there is nothing click at the loc of btn Next ... but that really slows things down. I suppose i could play with ways to speed things up but here again the DQB is supposed to be helping me knock this thing out quick. ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Database Query Builder 2
Jan was kind enough to point me to the check box 'Cache record set' as a means of getting the DQB to upload changes made to a field when the 'Update Field after editing' option is checked in the Database section of the inspector. I had thought Cache'ing the record set meant it would NOT be rechecking the mySQL database for changes but instead it appears to mean something like 'Keep the local cache up to date!' This really needs to go into the documentation, and the little video primers, because it is too elusive for a newbie. So now I can make changes but I still have one major hickup. If I click a button that is linked to the database such as a Next button set to 'Move to Next Record' then the field doesn't appear to ever get the close message needed to trigger the update. If I click any non DQB linked button or in the background then the save is made but if I go straight to a button like Next then the change is lost. I created a workaround by putting the Next button off screen and then making a fake Next button that does this ... click at 1,1 -- where there is nothing click at the loc of btn Next ... but that really slows things down. I suppose i could play with ways to speed things up but here again the DQB is supposed to be helping me knock this thing out quick. Any other half-documented features out there to which i should be paying attetion ?Thanks. ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: DataBase Query Builder
--- [EMAIL PROTECTED] wrote: It doesn't look like an auto Refresh of the query was ever incorporated into the DB Query Builder. Changes to a field, which do update the database, are not visible when you come back to that record. Is there a simple way to get around this? Thank you. One of the problems is that when a script updates the data in the back-end database, the corresponding data in the revdb cursor is not updated. You can work around this by ticking the 'Cache record set' checkbox in the database query builder. However, it is not completely Model-View-Controller yet, as placing the same database column on two different fields on the same card will not update the other field. Btw, if you want to refresh a single query (thsu reconnecting to the database and fetching all the column values again), you can use the command 'revRefreshQuery name of the query' Hope this helped, Jan Schenkel. Quartam - Tools for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: DataBase Query Builder
I have a little button that says refresh which I have to push. I never did automate it because it takes so long. On 5/12/05 11:10 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: It doesn't look like an auto Refresh of the query was ever incorporated into the DB Query Builder. Changes to a field, which do update the database, are not visible when you come back to that record. Is there a simple way to get around this? Thank you. ___ use-revolution mailing list use-revolution@lists.runrev.com 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 91 Puerto Real, PR 00740 ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
DataBase Query Builder
It doesn't look like an auto Refresh of the query was ever incorporated into the DB Query Builder. Changes to a field, which do update the database, are not visible when you come back to that record. Is there a simple way to get around this? Thank you. ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Database Query Builder, commit changes
Hello, all I need to make some simple changes to a Valentina DB, the Query builder is a great tool and I have everything set to open the tables and edit the fields. The problem comes when I am saving the changes back. If I use the auto edit feature of the Query Builder I get no erros but the changed data is not committed, on refresh the original field contents show. I tried a button with revCommitDatabase currentDB and I get cant find handler error. I am sure there is something simple I am missing, thanks all Michael Parent Read Naturally 1-800-788-4085 ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder, commit changes
--- Michael Parent [EMAIL PROTECTED] wrote: Hello, all I need to make some simple changes to a Valentina DB, the Query builder is a great tool and I have everything set to open the tables and edit the fields. The problem comes when I am saving the changes back. If I use the auto edit feature of the Query Builder I get no erros but the changed data is not committed, on refresh the original field contents show. I tried a button with revCommitDatabase currentDB and I get cant find handler error. I am sure there is something simple I am missing, thanks all Michael Parent Hi Michael, Have you ticked the 'Cache record set' checkbox ? If you didn't, you may have refresh problems. When you explicitly refresh the query, do the changes show up or not ? Jan Schenkel. Quartam - Tools for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
RE: Database Query Builder, commit changes
Hello Jan, I did not check 'cache record set as I will be opening many different Db files. When I do a change and either click refresh query from Query Builder or through a Button set to the auto refresh action from Query Builder the original Data is displayed on screen. Michael Parent Read Naturally 1-800-788-4085 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Schenkel Sent: Monday, May 02, 2005 1:45 PM To: How to use Revolution Subject: Re: Database Query Builder, commit changes --- Michael Parent [EMAIL PROTECTED] wrote: Hello, all I need to make some simple changes to a Valentina DB, the Query builder is a great tool and I have everything set to open the tables and edit the fields. The problem comes when I am saving the changes back. If I use the auto edit feature of the Query Builder I get no erros but the changed data is not committed, on refresh the original field contents show. I tried a button with revCommitDatabase currentDB and I get cant find handler error. I am sure there is something simple I am missing, thanks all Michael Parent Hi Michael, Have you ticked the 'Cache record set' checkbox ? If you didn't, you may have refresh problems. When you explicitly refresh the query, do the changes show up or not ? Jan Schenkel. Quartam - Tools for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
RE: Database Query Builder, commit changes
--- michael parent [EMAIL PROTECTED] wrote: Hello Jan, I did not check 'cache record set as I will be opening many different Db files. When I do a change and either click refresh query from Query Builder or through a Button set to the auto refresh action from Query Builder the original Data is displayed on screen. Michael Parent Hi Michael, In that case it's not writing the data back to the database. Hmm, if you have selected the correct primary key, it ought to work. If not, you may have to check with Rev support to see what is causing you problem. Jan Schenkel. Quartam - Tools for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: MySQL Database Query Builder Question
Note that some ISPs block this capability... Mine does... cheers Xavier On 28.04.2005 06:00:02 use-revolution-bounces wrote: Hi Martin, I'm trying to connect to my database which is hosted by oneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I try to press the connect button I get an error Unknown MySQL Host 'db141.oneandone.co.uk' (11004)' I am able to connect to the database in PHP MyAdmin without any problems! The only thing I can think of that could be causing this is the syntax of the host name!! maybe I'm wrong, has anyone had this problem? When I tried to find the IP address for db141.oneandone.co.uk, I got nothing. However I was able to get an address for oneandone.co.uk using the hostNameToAddress() function. If the Rev database query builder uses the hostNameToAddress function before trying to connect, it isn't going to work for the host name you have supplied. What happens if you use just oneandone.co.uk? When you connect using PHP, does it use the standard MySQL port (3306)? If not, you need to add this to the host name e.g. oneandone.co.uk:12345 where 12345 is my imaginary port number. HTH, Sarah ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution - Visit us at http://www.clearstream.com IMPORTANT MESSAGEInternet communications are not secure and therefore Clearstream International does not accept legal responsibility for the contents of this message.The information contained in this e-mail is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any views expressed in this e-mail are those of the individual sender, except where the sender specifically states them to be the views of Clearstream International or of any of its affiliates or subsidiaries.END OF DISCLAIMER ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
RE: MySQL Database Query Builder Question
Thanks Sarah Xavier With PHP 3306 is the port used, I tried changing to 'oneandone.co.uk:port' with many variations, to no avail. It seems that Xavier hit the nail on the head, my ISP wont allow this type of access!! I really cant see the point of having a database that I cant access. Can anyone recommend a good ISP with 'proper' database hosting (MySQL PHP etc...) Regards Martin McCarrick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sarah Reichelt Sent: 28 April 2005 05:00 To: How to use Revolution Subject: Re: MySQL Database Query Builder Question Hi Martin, I'm trying to connect to my database which is hosted by oneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I try to press the connect button I get an error Unknown MySQL Host 'db141.oneandone.co.uk' (11004)' I am able to connect to the database in PHP MyAdmin without any problems! The only thing I can think of that could be causing this is the syntax of the host name!! maybe I'm wrong, has anyone had this problem? When I tried to find the IP address for db141.oneandone.co.uk, I got nothing. However I was able to get an address for oneandone.co.uk using the hostNameToAddress() function. If the Rev database query builder uses the hostNameToAddress function before trying to connect, it isn't going to work for the host name you have supplied. What happens if you use just oneandone.co.uk? When you connect using PHP, does it use the standard MySQL port (3306)? If not, you need to add this to the host name e.g. oneandone.co.uk:12345 where 12345 is my imaginary port number. HTH, Sarah ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: MySQL Database Query Builder Question
Hello Martin, It's a long shot, but there is one more thing to check before giving up... Using PhpMyAdmin, have a look at the privilages that are set up for your DB and make sure it is set to % any, which will allow access from any domain address. -Doc- On 4/28/05, Martin McCarrick [EMAIL PROTECTED] wrote: Xavier Oneandone.co.uk use call centre's in the far east, it's not a pleasant experience trying to simply understand what they are saying, imagine trying to negotiate!! It's a bit flippant I know but my nerve's have been taken to the limit with call centre's. I would love to speak to an English speaking person who I can understand who isn't simply referencing a FAQ (that I've already studied) to provide answers. I think id like to simply change ISP (out the frying pan!) Thanks for your help Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 28 April 2005 09:18 To: How to use Revolution Subject: RE: MySQL Database Query Builder Question Martin, Later I'll be trying to drive the phpmyadmin post and gets to make it run but as you imagine it's not very efficient. However i dont really need a live access to it... Have you tried negotiating with the ISP for it? cheers Xavier On 28.04.2005 10:06:43 use-revolution-bounces wrote: Thanks Sarah Xavier With PHP 3306 is the port used, I tried changing to 'oneandone.co.uk:port' with many variations, to no avail. It seems that Xavier hit the nail on the head, my ISP wont allow this type of access!! I really cant see the point of having a database that I cant access. Can anyone recommend a good ISP with 'proper' database hosting (MySQL PHP etc...) Regards Martin McCarrick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sarah Reichelt Sent: 28 April 2005 05:00 To: How to use Revolution Subject: Re: MySQL Database Query Builder Question Hi Martin, I'm trying to connect to my database which is hosted by oneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I try to press the connect button I get an error Unknown MySQL Host 'db141.oneandone.co.uk' (11004)' I am able to connect to the database in PHP MyAdmin without any problems! The only thing I can think of that could be causing this is the syntax of the host name!! maybe I'm wrong, has anyone had this problem? When I tried to find the IP address for db141.oneandone.co.uk, I got nothing. However I was able to get an address for oneandone.co.uk using the hostNameToAddress() function. If the Rev database query builder uses the hostNameToAddress function before trying to connect, it isn't going to work for the host name you have supplied. What happens if you use just oneandone.co.uk? When you connect using PHP, does it use the standard MySQL port (3306)? If not, you need to add this to the host name e.g. oneandone.co.uk:12345 where 12345 is my imaginary port number. HTH, Sarah ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution - Visit us at http://www.clearstream.com IMPORTANT MESSAGEInternet communications are not secure and therefore Clearstream International does not accept legal responsibility for the contents of this message.The information contained in this e-mail is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any views expressed in this e-mail are those of the individual sender, except where the sender specifically states them to be the views of Clearstream International or of any of its affiliates or subsidiaries.END OF DISCLAIMER ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: MySQL Database Query Builder Question
Doc, Is this in the config.php file or? cheers Xavier On 28.04.2005 11:32:00 use-revolution-bounces wrote: Hello Martin, It's a long shot, but there is one more thing to check before giving up... Using PhpMyAdmin, have a look at the privilages that are set up for your DB and make sure it is set to % any, which will allow access from any domain address. -Doc- On 4/28/05, Martin McCarrick [EMAIL PROTECTED] wrote: Xavier Oneandone.co.uk use call centre's in the far east, it's not a pleasant experience trying to simply understand what they are saying, imagine trying to negotiate!! It's a bit flippant I know but my nerve's have been taken to the limit with call centre's. I would love to speak to an English speaking person who I can understand who isn't simply referencing a FAQ (that I've already studied) to provide answers. I think id like to simply change ISP (out the frying pan!) Thanks for your help Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 28 April 2005 09:18 To: How to use Revolution Subject: RE: MySQL Database Query Builder Question Martin, Later I'll be trying to drive the phpmyadmin post and gets to make it run but as you imagine it's not very efficient. However i dont really need a live access to it... Have you tried negotiating with the ISP for it? cheers Xavier On 28.04.2005 10:06:43 use-revolution-bounces wrote: Thanks Sarah Xavier With PHP 3306 is the port used, I tried changing to 'oneandone.co.uk:port' with many variations, to no avail. It seems that Xavier hit the nail on the head, my ISP wont allow this type of access!! I really cant see the point of having a database that I cant access. Can anyone recommend a good ISP with 'proper' database hosting (MySQL PHP etc...) Regards Martin McCarrick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sarah Reichelt Sent: 28 April 2005 05:00 To: How to use Revolution Subject: Re: MySQL Database Query Builder Question Hi Martin, I'm trying to connect to my database which is hosted by oneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I try to press the connect button I get an error Unknown MySQL Host 'db141.oneandone.co.uk' (11004)' I am able to connect to the database in PHP MyAdmin without any problems! The only thing I can think of that could be causing this is the syntax of the host name!! maybe I'm wrong, has anyone had this problem? When I tried to find the IP address for db141.oneandone.co.uk, I got nothing. However I was able to get an address for oneandone.co.uk using the hostNameToAddress() function. If the Rev database query builder uses the hostNameToAddress function before trying to connect, it isn't going to work for the host name you have supplied. What happens if you use just oneandone.co.uk? When you connect using PHP, does it use the standard MySQL port (3306)? If not, you need to add this to the host name e.g. oneandone.co.uk:12345 where 12345 is my imaginary port number. HTH, Sarah ___ use-revolution mailing list use-re - Visit us at http://www.clearstream.com IMPORTANT MESSAGEInternet communications are not secure and therefore Clearstream International does not accept legal responsibility for the contents of this message.The information contained in this e-mail is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any views expressed in this e-mail are those of the individual sender, except where the sender specifically states them to be the views of Clearstream International or of any of its affiliates or subsidiaries.END OF DISCLAIMER ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: MySQL Database Query Builder Question
Hello Xavier, Actually there is a link directly from the main phpMyAdmin page where you can check and or change the status (assuming you have the right access privilages). I know that on our LAN, I cannot connect from a remote work station without changing the Host settings HTH, -Doc- On 4/28/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Doc, Is this in the config.php file or? cheers Xavier On 28.04.2005 11:32:00 use-revolution-bounces wrote: Hello Martin, It's a long shot, but there is one more thing to check before giving up... Using PhpMyAdmin, have a look at the privilages that are set up for your DB and make sure it is set to % any, which will allow access from any domain address. -Doc- On 4/28/05, Martin McCarrick [EMAIL PROTECTED] wrote: Xavier Oneandone.co.uk use call centre's in the far east, it's not a pleasant experience trying to simply understand what they are saying, imagine trying to negotiate!! It's a bit flippant I know but my nerve's have been taken to the limit with call centre's. I would love to speak to an English speaking person who I can understand who isn't simply referencing a FAQ (that I've already studied) to provide answers. I think id like to simply change ISP (out the frying pan!) Thanks for your help Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 28 April 2005 09:18 To: How to use Revolution Subject: RE: MySQL Database Query Builder Question Martin, Later I'll be trying to drive the phpmyadmin post and gets to make it run but as you imagine it's not very efficient. However i dont really need a live access to it... Have you tried negotiating with the ISP for it? cheers Xavier On 28.04.2005 10:06:43 use-revolution-bounces wrote: Thanks Sarah Xavier With PHP 3306 is the port used, I tried changing to 'oneandone.co.uk:port' with many variations, to no avail. It seems that Xavier hit the nail on the head, my ISP wont allow this type of access!! I really cant see the point of having a database that I cant access. Can anyone recommend a good ISP with 'proper' database hosting (MySQL PHP etc...) Regards Martin McCarrick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sarah Reichelt Sent: 28 April 2005 05:00 To: How to use Revolution Subject: Re: MySQL Database Query Builder Question Hi Martin, I'm trying to connect to my database which is hosted by oneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I try to press the connect button I get an error Unknown MySQL Host 'db141.oneandone.co.uk' (11004)' I am able to connect to the database in PHP MyAdmin without any problems! The only thing I can think of that could be causing this is the syntax of the host name!! maybe I'm wrong, has anyone had this problem? When I tried to find the IP address for db141.oneandone.co.uk, I got nothing. However I was able to get an address for oneandone.co.uk using the hostNameToAddress() function. If the Rev database query builder uses the hostNameToAddress function before trying to connect, it isn't going to work for the host name you have supplied. What happens if you use just oneandone.co.uk? When you connect using PHP, does it use the standard MySQL port (3306)? If not, you need to add this to the host name e.g. oneandone.co.uk:12345 where 12345 is my imaginary port number. HTH, Sarah ___ use-revolution mailing list use-re Visit us at http://www.clearstream.com IMPORTANT MESSAGE Internet communications are not secure and therefore Clearstream International does not accept legal responsibility for the contents of this message. The information contained in this e-mail is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any views expressed in this e-mail are those of the individual sender, except where the sender specifically states them to be the views of Clearstream International or of any of its affiliates or subsidiaries. END OF DISCLAIMER ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use
Re: MySQL Database Query Builder Question
As an afterthought, I'd highly recommend that you have a good look at the mySQL documentation in regards to security settings. It would be a good thing to understand the issues *before* making changes. :) -Doc- On 4/28/05, docmann [EMAIL PROTECTED] wrote: Hello Xavier, Actually there is a link directly from the main phpMyAdmin page where you can check and or change the status (assuming you have the right access privilages). I know that on our LAN, I cannot connect from a remote work station without changing the Host settings HTH, -Doc- On 4/28/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Doc, Is this in the config.php file or? cheers Xavier On 28.04.2005 11:32:00 use-revolution-bounces wrote: Hello Martin, It's a long shot, but there is one more thing to check before giving up... Using PhpMyAdmin, have a look at the privilages that are set up for your DB and make sure it is set to % any, which will allow access from any domain address. -Doc- On 4/28/05, Martin McCarrick [EMAIL PROTECTED] wrote: Xavier Oneandone.co.uk use call centre's in the far east, it's not a pleasant experience trying to simply understand what they are saying, imagine trying to negotiate!! It's a bit flippant I know but my nerve's have been taken to the limit with call centre's. I would love to speak to an English speaking person who I can understand who isn't simply referencing a FAQ (that I've already studied) to provide answers. I think id like to simply change ISP (out the frying pan!) Thanks for your help Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 28 April 2005 09:18 To: How to use Revolution Subject: RE: MySQL Database Query Builder Question Martin, Later I'll be trying to drive the phpmyadmin post and gets to make it run but as you imagine it's not very efficient. However i dont really need a live access to it... Have you tried negotiating with the ISP for it? cheers Xavier On 28.04.2005 10:06:43 use-revolution-bounces wrote: Thanks Sarah Xavier With PHP 3306 is the port used, I tried changing to 'oneandone.co.uk:port' with many variations, to no avail. It seems that Xavier hit the nail on the head, my ISP wont allow this type of access!! I really cant see the point of having a database that I cant access. Can anyone recommend a good ISP with 'proper' database hosting (MySQL PHP etc...) Regards Martin McCarrick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sarah Reichelt Sent: 28 April 2005 05:00 To: How to use Revolution Subject: Re: MySQL Database Query Builder Question Hi Martin, I'm trying to connect to my database which is hosted by oneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I try to press the connect button I get an error Unknown MySQL Host 'db141.oneandone.co.uk' (11004)' I am able to connect to the database in PHP MyAdmin without any problems! The only thing I can think of that could be causing this is the syntax of the host name!! maybe I'm wrong, has anyone had this problem? When I tried to find the IP address for db141.oneandone.co.uk, I got nothing. However I was able to get an address for oneandone.co.uk using the hostNameToAddress() function. If the Rev database query builder uses the hostNameToAddress function before trying to connect, it isn't going to work for the host name you have supplied. What happens if you use just oneandone.co.uk? When you connect using PHP, does it use the standard MySQL port (3306)? If not, you need to add this to the host name e.g. oneandone.co.uk:12345 where 12345 is my imaginary port number. HTH, Sarah ___ use-revolution mailing list use-re Visit us at http://www.clearstream.com IMPORTANT MESSAGE Internet communications are not secure and therefore Clearstream International does not accept legal responsibility for the contents of this message. The information contained in this e-mail is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may
RE: MySQL Database Query Builder Question
Hi Docmann It seems that I cant even use phpAdmin anymoreI have it installed (v 2.3.2) on my site but cant access it anymore as I would normally, the link I had saved in favourites does nothing now! Not good. Oneandone.co.uk now have a MySQL admin link from within their own web control panel which utilises phpMyadmin 2.6.1, in it there is no access to privileges. I think they have restricted access in favour of me 'upgrading' by the look of it. Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of docmann Sent: 28 April 2005 10:49 To: [EMAIL PROTECTED] Cc: How to use Revolution Subject: Re: MySQL Database Query Builder Question Hello Xavier, Actually there is a link directly from the main phpMyAdmin page where you can check and or change the status (assuming you have the right access privilages). I know that on our LAN, I cannot connect from a remote work station without changing the Host settings HTH, -Doc- On 4/28/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Doc, Is this in the config.php file or? cheers Xavier On 28.04.2005 11:32:00 use-revolution-bounces wrote: Hello Martin, It's a long shot, but there is one more thing to check before giving up... Using PhpMyAdmin, have a look at the privilages that are set up for your DB and make sure it is set to % any, which will allow access from any domain address. -Doc- On 4/28/05, Martin McCarrick [EMAIL PROTECTED] wrote: Xavier Oneandone.co.uk use call centre's in the far east, it's not a pleasant experience trying to simply understand what they are saying, imagine trying to negotiate!! It's a bit flippant I know but my nerve's have been taken to the limit with call centre's. I would love to speak to an English speaking person who I can understand who isn't simply referencing a FAQ (that I've already studied) to provide answers. I think id like to simply change ISP (out the frying pan!) Thanks for your help Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 28 April 2005 09:18 To: How to use Revolution Subject: RE: MySQL Database Query Builder Question Martin, Later I'll be trying to drive the phpmyadmin post and gets to make it run but as you imagine it's not very efficient. However i dont really need a live access to it... Have you tried negotiating with the ISP for it? cheers Xavier On 28.04.2005 10:06:43 use-revolution-bounces wrote: Thanks Sarah Xavier With PHP 3306 is the port used, I tried changing to 'oneandone.co.uk:port' with many variations, to no avail. It seems that Xavier hit the nail on the head, my ISP wont allow this type of access!! I really cant see the point of having a database that I cant access. Can anyone recommend a good ISP with 'proper' database hosting (MySQL PHP etc...) Regards Martin McCarrick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sarah Reichelt Sent: 28 April 2005 05:00 To: How to use Revolution Subject: Re: MySQL Database Query Builder Question Hi Martin, I'm trying to connect to my database which is hosted byoneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I try to press the connect button I get an error Unknown MySQLHost 'db141.oneandone.co.uk' (11004)' I am able to connect to the database in PHP MyAdmin without any problems! The only thing I can think of that could be causing this is the syntax of the host name!! maybe I'm wrong, has anyone had this problem? When I tried to find the IP address for db141.oneandone.co.uk, I got nothing. However I was able to get an address for oneandone.co.uk using the hostNameToAddress() function. If the Rev database query builder uses the hostNameToAddress function before trying to connect, it isn't going to work for the host name you have supplied. What happens if you use just oneandone.co.uk? When you connect using PHP, does it use the standard MySQL port (3306)? If not, you need to add this to the host name e.g. oneandone.co.uk:12345 where 12345 is my imaginary port number. HTH, Sarah ___ use-revolution mailing list use-re Visit us at http://www.clearstream.com IMPORTANT MESSAGE Internet communications are not secure and therefore Clearstream International does not accept legal responsibility for the contents of this message
RE: MySQL Database Query Builder Question
An excerpt taken from oneandone- The MySQL database is stored on a separate database server behind a firewall to protect your data. You can only access this database server and your database exclusively through your site. Direct access to the MySQL database using a home PC (external ODBC connection) cannot be established. I'm moving Host. Can you suggest anyone? Regards Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of docmann Sent: 28 April 2005 11:16 To: [EMAIL PROTECTED] Cc: How to use Revolution Subject: Re: MySQL Database Query Builder Question As an afterthought, I'd highly recommend that you have a good look at the mySQL documentation in regards to security settings. It would be a good thing to understand the issues *before* making changes. :) -Doc- On 4/28/05, docmann [EMAIL PROTECTED] wrote: Hello Xavier, Actually there is a link directly from the main phpMyAdmin page where you can check and or change the status (assuming you have the right access privilages). I know that on our LAN, I cannot connect from a remote work station without changing the Host settings HTH, -Doc- On 4/28/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Doc, Is this in the config.php file or? cheers Xavier On 28.04.2005 11:32:00 use-revolution-bounces wrote: Hello Martin, It's a long shot, but there is one more thing to check before giving up... Using PhpMyAdmin, have a look at the privilages that are set up for your DB and make sure it is set to % any, which will allow access from any domain address. -Doc- On 4/28/05, Martin McCarrick [EMAIL PROTECTED] wrote: Xavier Oneandone.co.uk use call centre's in the far east, it's not a pleasant experience trying to simply understand what they are saying, imagine trying to negotiate!! It's a bit flippant I know but my nerve's have been taken to the limit with call centre's. I would love to speak to an English speaking person who I can understand who isn't simply referencing a FAQ (that I've already studied) to provide answers. I think id like to simply change ISP (out the frying pan!) Thanks for your help Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 28 April 2005 09:18 To: How to use Revolution Subject: RE: MySQL Database Query Builder Question Martin, Later I'll be trying to drive the phpmyadmin post and gets to make it run but as you imagine it's not very efficient. However i dont really need a live access to it... Have you tried negotiating with the ISP for it? cheers Xavier On 28.04.2005 10:06:43 use-revolution-bounces wrote: Thanks Sarah Xavier With PHP 3306 is the port used, I tried changing to 'oneandone.co.uk:port' with many variations, to no avail. It seems that Xavier hit the nail on the head, my ISP wont allow this type of access!! I really cant see the point of having a database that I cant access. Can anyone recommend a good ISP with 'proper' database hosting (MySQL PHP etc...) Regards Martin McCarrick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sarah Reichelt Sent: 28 April 2005 05:00 To: How to use Revolution Subject: Re: MySQL Database Query Builder Question Hi Martin, I'm trying to connect to my database which is hosted byoneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I try to press the connect button I get an error Unknown MySQLHost 'db141.oneandone.co.uk' (11004)' I am able to connect to the database in PHP MyAdmin without anyproblems! The only thing I can think of that could be causing this is thesyntax of the host name!! maybe I'm wrong, has anyone had this problem? When I tried to find the IP address for db141.oneandone.co.uk, I got nothing. However I was able to get an address for oneandone.co.uk using the hostNameToAddress() function. If the Rev database query builder uses the hostNameToAddress function before trying to connect, it isn't going to work for the host name you have supplied. What happens if you use just oneandone.co.uk? When you connect using PHP, does it use the standard MySQL port (3306)? If not, you need to add this to the host name e.g. oneandone.co.uk:12345 where 12345 is my imaginary port number. HTH, Sarah ___ use-revolution mailing list
Re: MySQL Database Query Builder Question
Hi Martin, I just had a look at the feature matrix provided by your hosting company and an upgrade may in fact be required, depending on the hosting package you have now Bummer. :( -Doc- On 4/28/05, Martin McCarrick [EMAIL PROTECTED] wrote: Hi Docmann It seems that I cant even use phpAdmin anymoreI have it installed (v 2.3.2) on my site but cant access it anymore as I would normally, the link I had saved in favourites does nothing now! Not good. Oneandone.co.uk now have a MySQL admin link from within their own web control panel which utilises phpMyadmin 2.6.1, in it there is no access to privileges. I think they have restricted access in favour of me 'upgrading' by the look of it ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
RE: MySQL Database Query Builder Question
Dreamhost. $10/month for all goodies. Great dedicated deals too. I host 15 sites there. Even the 'shared' hosting rocks... Can anyone recommend a good ISP with 'proper' database hosting (MySQL PHP etc...) Regards Martin McCarrick ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: MySQL Database Query Builder Question
Hi Martin, I'm trying to connect to my database which is hosted by oneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I try to press the connect button I get an error Unknown MySQL Host 'db141.oneandone.co.uk' (11004)' I am able to connect to the database in PHP MyAdmin without any problems! The only thing I can think of that could be causing this is the syntax of the host name!! maybe I'm wrong, has anyone had this problem? When I tried to find the IP address for db141.oneandone.co.uk, I got nothing. However I was able to get an address for oneandone.co.uk using the hostNameToAddress() function. If the Rev database query builder uses the hostNameToAddress function before trying to connect, it isn't going to work for the host name you have supplied. What happens if you use just oneandone.co.uk? When you connect using PHP, does it use the standard MySQL port (3306)? If not, you need to add this to the host name e.g. oneandone.co.uk:12345 where 12345 is my imaginary port number. HTH, Sarah ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
MySQL Database Query Builder Question
Hi, I'm trying to connect to my database which is hosted by oneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I try to press the connect button I get an error Unknown MySQL Host 'db141.oneandone.co.uk' (11004)' I am able to connect to the database in PHP MyAdmin without any problems! The only thing I can think of that could be causing this is the syntax of the host name!! maybe I'm wrong, has anyone had this problem? I've tried the MySQL database example in RR's video tutorials and it connects fine. Thank you Martin McCarrick ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Database Query Builder bug - only returning one row, and not updating...
Hi Folks, is anyone here using Database Query Builder on Rev 2.2.1? I am using it and using it to display the contents of a query in a nice listbox field. The query should return 3 rows (it does that on phpMyAdmin, the same query). It returns only one row on rev. Also I am making use of the arcane function revSetSQLOfQuery to change the parameter of the query on runtime. it is working for when I check the Database Query Builder, the query is the last one I set. Any clues here? That appears a nasty bug... Thanks in advance Andre -- Andre Alves Garzia 2004 BRAZIL http://studio.soapdog.org ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Database query builder not really a bug just not finished
On 7/21/04 1:38 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: is anyone here using Database Query Builder on Rev 2.2.1? I am using it and using it to display the contents of a query in a nice listbox field. The query should return 3 rows (it does that on phpMyAdmin, the same query). It returns only one row on rev. Also I am making use of the arcane function revSetSQLOfQuery to change the parameter of the query on runtime. it is working for when I check the Database Query Builder, the query is the last one I set. Any clues here? That appears a nasty bug... The query builder and its nice show record function only works for one record at a time. You can do this: on mouseUp put first word of selectedtext of me into tshipID put SELECT * FROM voyages WHERE shipID=' \ tshipID ' \ into tSQLStatement revSetSQLOfQuery Connect,tSQLStatement end mouseUp (sorry my example is not more generic -- my query builder query is called Connect) and then you will get a subset of your data but still only one record will show at a time in the fields that are show a connection and update data etc. Then you use buttons set to move to next record to see each record from your query. If you want to see a list of records like to put them in a pop-up or something you don't use the query builder but instead do it manually (and you can make a nice front end that mixes what the query builder does well with what you have to do manually). Also try using CocoaMySQL instead of phpMyAdmin and you have more functions and can look stuff up quickly (especially if you have a complex multi-table database) while programming in RUNREV at the same time. ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database query builder not really a bug just not finished
Thank you for you very usefull reply Bill I have cocoaMySQL here but it keeps quiting, so I use my phpmyAdmin from my web host control pannel, it's all integrated so no fuss here. Also, we used to have a nice show all records on that database part of the inspector, I used that to create listboxes like: SQL: select name from records. On the inspector I would choose a field and use the show all on the database part of the inspector, that worked fine! where did that option go? that what I was talking about, not that it showed only one record, I reviewed my old code and that the way I used to do. I would create a listbox, fill it with names from the show all option, then on the double click of the listbox I would acquire the desired name, change the SQL query to reflect that choice, query the server, and move to a nice record editing card. It worked fine, but now with the show all missing, I think I'll have to code it by hand (and not by mouse as I wanted). cheers andre On Jul 21, 2004, at 3:42 PM, Bill wrote: On 7/21/04 1:38 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: is anyone here using Database Query Builder on Rev 2.2.1? I am using it and using it to display the contents of a query in a nice listbox field. The query should return 3 rows (it does that on phpMyAdmin, the same query). It returns only one row on rev. Also I am making use of the arcane function revSetSQLOfQuery to change the parameter of the query on runtime. it is working for when I check the Database Query Builder, the query is the last one I set. Any clues here? That appears a nasty bug... The query builder and its nice show record function only works for one record at a time. You can do this: on mouseUp put first word of selectedtext of me into tshipID put SELECT * FROM voyages WHERE shipID=' \ tshipID ' \ into tSQLStatement revSetSQLOfQuery Connect,tSQLStatement end mouseUp (sorry my example is not more generic -- my query builder query is called Connect) and then you will get a subset of your data but still only one record will show at a time in the fields that are show a connection and update data etc. Then you use buttons set to move to next record to see each record from your query. If you want to see a list of records like to put them in a pop-up or something you don't use the query builder but instead do it manually (and you can make a nice front end that mixes what the query builder does well with what you have to do manually). Also try using CocoaMySQL instead of phpMyAdmin and you have more functions and can look stuff up quickly (especially if you have a complex multi-table database) while programming in RUNREV at the same time. ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution -- Andre Alves Garzia 2004 Soap Dog Studios - BRAZIL http://studio.soapdog.org ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
BUG: Database Query Builder Feature Missing on 2.2.1...
Hi Folks, If you look into the documentation on Databases on the rev docs under About connecting to and using SQL Databases you'll see an article about Database Query Builder, under the topic Displaying automatic query data you'll that there's a specific part detailing how to use Show All to display all data from a query. That feature (Show All) is missing here. I just made an empty mainstack, created a query to my mySQL server, launched the inspector and the option is not there. Can someone explain me what happened? Can someone here tell me if this feature was removed? That was one of the most usefull Database Query Builder feature for is allowed us to create listboxes without coding them. Ie: We could retrieve all names from a DB, pipe tem to a listbox and make a nice select your name widget. Without this, we must code by hand, deal with cursors, open the db and closing it... it would spoil the Rev DB experience and it's ease of use. I am querying this list before bugzilling this, can someone here give me a clue? Kevin? Tuviah? anyone? thanks in advance andre -- Andre Alves Garzia 2004 Soap Dog Studios - BRAZIL http://studio.soapdog.org ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: HELP!!! (was Re: is Database Query Builder bugged for Rev 2.2.x?)
--- Andre Garzia [EMAIL PROTECTED] wrote: Hi Folks, I think my Stack is damaged, I managed to use the Query Builder with a new stack, but with this stack it does not work up... even on Rev 2.1. I think Revolution exploded when I was working with this stack sometime ago with queries, I think it might have corrupt Query Builder data in it that is preventing it to work. How to I clean any trace of the query builder in a stack, I know it must put its data as custom properties, hidden somewhere, how to I clean them so that I might use it again. help!!! andre Hi Andre, The queries themselves are stored in unplaced background groups. You can get a list of their control names using the undocumented 'revQueryObjects()' function. You'll have to set the defaultStack to the correct stack first, though, but this will give you a list of objects to manipulate and/or delete from the problem stack. Hope this helped, Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
is Database Query Builder bugged for Rev 2.2.x?
Hi Folks, I just opened a old project of mine for I decided to take it to the summit. I was going to update the Queries I made with Database Query Builder so that they reflect my new MySQL home, but guess what? Pressing the + button of the Query Builder does nothing at all... I quited revolution, launched it again, create a new empty mainstack then tried to create a new query with the query builder, no response at all.. click the add new query button, the builder sits with it's controls disabled and thats all... tried on 2.2 and 2.2.1 anyone with the same trouble? Cheers Andre -- Andre Alves Garzia 2004 BRAZIL http://studio.soapdog.org ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
How to change Database Query Builder connection info at runtime?
Hi Folks, I'll be deploying a simple DB app for an enterprize here at Brazil but they do not know where their mySQL server will be running, is there a way that I can change Database Query Builder connection info at runtime? this way I could just pop a dialog asking for the info at startup and all the queries would work... Cheers Andre -- Andre Alves Garzia 2004 BRAZIL http://studio.soapdog.org ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: How to change Database Query Builder connection info at runtime?
--- Andre Garzia [EMAIL PROTECTED] wrote: Hi Folks, I'll be deploying a simple DB app for an enterprize here at Brazil but they do not know where their mySQL server will be running, is there a way that I can change Database Query Builder connection info at runtime? this way I could just pop a dialog asking for the info at startup and all the queries would work... Cheers Andre Hi Andre, As I remembered looking into this before for someone, I dug up the relevant posts from the mailing list archive : http://lists.runrev.com/pipermail/use-revolution/2003-December/026932.html http://lists.runrev.com/pipermail/use-revolution/2003-December/026982.html Hope this helped, Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: How to change Database Query Builder connection info at runtime?
Hi Andre, As I remembered looking into this before for someone, I dug up the relevant posts from the mailing list archive : http://lists.runrev.com/pipermail/use-revolution/2003-December/ 026932.html http://lists.runrev.com/pipermail/use-revolution/2003-December/ 026982.html Hope this helped, Jan Schenkel. Jan, Thank you very much! thats just what I needed!!! :D Cheers Andre -- Andre Alves Garzia 2004 BRAZIL http://studio.soapdog.org ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Two Questions on Database Query Builder
--- Andre Garzia [EMAIL PROTECTED] wrote: Hi Folks, Is there a way to change connections parameters (server, user, pass) at run time? See the following answers from last month's list archives : http://lists.runrev.com/pipermail/use-revolution/2003-December/026932.html http://lists.runrev.com/pipermail/use-revolution/2003-December/026982.html And what about SQL joins, if I try to use something like SELECT * FROM names, projects WHERE projects.manager = names.id will it work in the Database Query Builder, like being able to set control for columns of both tables? Have you tried ? *grin* Just tried it here, and it seems to work just fine, allowing you to fetch fields from both tables when you link fields to the query. Cheers, and thanks in advance. Andre Alves Garzia ð 2003 ð BRAZIL http://www.soapdog.org Hope this helped, Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Two Questions on Database Query Builder
On Jan 12, 2004, at 8:40 AM, Jan Schenkel wrote: Have you tried ? *grin* Just tried it here, and it seems to work just fine, allowing you to fetch fields from both tables when you link fields to the query. Cheers, and thanks in advance. Andre Alves Garzia 2003 BRAZIL http://www.soapdog.org Hope this helped, Jan Schenkel. Jan, Thanks for your help! On trying it, yes I tried but there was a problem since both tables used the same field names so MySQL shouted that the query was ambigous, that was fixed, it was a problem with MySQL, SQL Query and me, nothing to do with revolution, but I was slow to understand. Thanks Again Cheers Andre Andre Garzia 2003 imac2 ibook p100 e uma torradeira ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Two Questions on Database Query Builder
Hi Folks, Is there a way to change connections parameters (server, user, pass) at run time? And what about SQL joins, if I try to use something like SELECT * FROM names, projects WHERE projects.manager = names.id will it work in the Database Query Builder, like being able to set control for columns of both tables? Cheers, and thanks in advance. Andre Alves Garzia 2003 BRAZIL http://www.soapdog.org ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Is there a func for changing Database Query Builder connection parameters at runtime?
Hi revFolks, I am making an app (Called DataJunior, nice app, http://www.soapdog.org/blog for info) which uses a mix of DB handlers and Database Query Builder stuff... This application is a mix of substacks, each substack is like an self-contained application dealing with a very specific problem, like for example there's an addressbook like app, there's a team management app... When the substack needed more complex database resources, I wrote my own functions but when it was a simple query I used Database Query Builder (It's a cool thing!). It was like dream coding, adding complexity only when needed, but I didn't foresaw one problem. The bootstrap problem, like setting it up for the first run on another computer that is not mine. For my hand coded funcs, I made a substack called DBConf which is responsible for loading itself on launch time, checking for Database connection parameters, if they are not present (first run) asking for them, saving it, opening the connection. So far so good, I've got a reusable substack that will take care of opening and closing connections to database and will put all the usefull info in a nice global. The problem is, How do I take this parameters (host, username, pass...) to Database Query Builder. See, I can garantee that my funcs will work, but Automatic Queries are strange entities sometimes. Here, everything points to home.soapdog.org, but this will be deployed to an enterprize and hell knows where they will install MySQL, I would not like to build a new version everytime they feel like changing their ips or their servernames There must be an undocummented nice way like revHeyChangeAutoQueriesParametersToWhereverMyServerIs or something near this.. :-D So... anyone here can point me to some frontscript or info? Also, I am thinking about posting in the web a developer journal on this app and making the code available, would people here find this usefull? Cheers Andre Alves Garzia 2003 BRAZIL http://www.soapdog.org ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder
Tnx Jan, This works! From: Jan Schenkel [EMAIL PROTECTED] Reply-To: How to use Revolution [EMAIL PROTECTED] Date: Sat, 6 Dec 2003 03:13:33 -0800 (PST) To: How to use Revolution [EMAIL PROTECTED] Subject: Re: Database Query Builder --- [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Jan, It's not working, I don't think I understand how to use this... :( When I setup a databse-connection and use put revQueryLongName(cREVDatabaseQuery[dbhost]) into msg I don't get anything... What am I doing wrong? Ton Hi Ton, Maybe the following is a better example. Suppose you have a query named MyFirstQuery. -- put revQueryLongName(MyFirstQuery) into \ tQueryObject put the cREVDatabaseQuery[dbhost] of tQueryObject -- For a list of all your query objects, use the undocumented function 'revQueryObjects' So if you only want a quick way to change the host for all your queries, you can do something like : -- put _the_new_host_ into tNewHost put revQueryObjects() into tQueryObjects repeat for each line tQueryObject in tQueryObjects set the cREVDatabaseQuery[dbhost] of \ tQueryObject to tNewHost end repeat -- Hope this helped, Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder
Jan, It's not working, I don't think I understand how to use this... :( When I setup a databse-connection and use put revQueryLongName(cREVDatabaseQuery[dbhost]) into msg I don't get anything... What am I doing wrong? Ton From: Jan Schenkel [EMAIL PROTECTED] Reply-To: How to use Revolution [EMAIL PROTECTED] Date: Fri, 5 Dec 2003 07:03:52 -0800 (PST) To: How to use Revolution [EMAIL PROTECTED] Subject: Re: Database Query Builder --- [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Question... When using the Database Query Builder, you have to enter the address of the database. But is there a way to create a preference-file which is loaded during startup, because I?m creating a mySQL-front-end which uses different databases (development db on server 1 and live db on server 2). Now I created my SQL-statements myself, so I check a preference-file at startup, which I manually can edit, or edit in my preference-tab in the program, but I would like to use the Database Query Builder and still be able to change and save these settings. Anyone any advice, because I can?t seem to find where the Database Query Builder gets and stores its data. Thanks in advance, Ton Kuypers Hi Ton, The revDatabase implementation is an interesting one, in that each and every query is actually an unplaced, empty group. The connection information for the query is stored in its custom property set named cREVDatabaseQuery : - cREVDatabaseQuery[dbtype] - cREVDatabaseQuery[dbhost] - cREVDatabaseQuery[dbdatabase] - cREVDatabaseQuery[dbport] - cREVDatabaseQuery[dbuser] - cREVDatabaseQuery[dbpassword] - cREVDatabaseQuery[dbssl] In order to get the actual group, you have to use the undocumented function 'revQueryLongName' ; hand it a query name and it gives you the long name of the group, after which you can play around with its custom properties from a script : -- put revQueryLongName(tQueryName) into tQueryObject set the cREVDatabaseQuery[dbhost] of \ tQueryObject to the.other.host -- Oh, a little note of warning : do not try to place the database query groups onto a card, or the query will stop working alltogether. Took me a while to figure that one out... Hope this helped, Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder
--- [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Jan, It's not working, I don't think I understand how to use this... :( When I setup a databse-connection and use put revQueryLongName(cREVDatabaseQuery[dbhost]) into msg I don't get anything... What am I doing wrong? Ton Hi Ton, Maybe the following is a better example. Suppose you have a query named MyFirstQuery. -- put revQueryLongName(MyFirstQuery) into \ tQueryObject put the cREVDatabaseQuery[dbhost] of tQueryObject -- For a list of all your query objects, use the undocumented function 'revQueryObjects' So if you only want a quick way to change the host for all your queries, you can do something like : -- put _the_new_host_ into tNewHost put revQueryObjects() into tQueryObjects repeat for each line tQueryObject in tQueryObjects set the cREVDatabaseQuery[dbhost] of \ tQueryObject to tNewHost end repeat -- Hope this helped, Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Don't everyone loves undocumented features (was Re: Database Query Builder)
Jan, this tips are forming what I call the The Black Voodoo Book of Revolution Internal tricks other time sparing code, you and the other revGurus out there got your own mailbox folder here where I store every bit of undocumented code that I see (I might need it later). We should put them all to revNet and revJournal. Thanks! Cheers Andre ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Database Query Builder
Question... When using the Database Query Builder, you have to enter the address of the database. But is there a way to create a preference-file which is loaded during startup, because I¹m creating a mySQL-front-end which uses different databases (development db on server 1 and live db on server 2). Now I created my SQL-statements myself, so I check a preference-file at startup, which I manually can edit, or edit in my preference-tab in the program, but I would like to use the Database Query Builder and still be able to change and save these settings. Anyone any advice, because I can¹t seem to find where the Database Query Builder gets and stores its data. Thanks in advance, Ton Kuypers ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder
--- [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Question... When using the Database Query Builder, you have to enter the address of the database. But is there a way to create a preference-file which is loaded during startup, because I¹m creating a mySQL-front-end which uses different databases (development db on server 1 and live db on server 2). Now I created my SQL-statements myself, so I check a preference-file at startup, which I manually can edit, or edit in my preference-tab in the program, but I would like to use the Database Query Builder and still be able to change and save these settings. Anyone any advice, because I can¹t seem to find where the Database Query Builder gets and stores its data. Thanks in advance, Ton Kuypers Hi Ton, The revDatabase implementation is an interesting one, in that each and every query is actually an unplaced, empty group. The connection information for the query is stored in its custom property set named cREVDatabaseQuery : - cREVDatabaseQuery[dbtype] - cREVDatabaseQuery[dbhost] - cREVDatabaseQuery[dbdatabase] - cREVDatabaseQuery[dbport] - cREVDatabaseQuery[dbuser] - cREVDatabaseQuery[dbpassword] - cREVDatabaseQuery[dbssl] In order to get the actual group, you have to use the undocumented function 'revQueryLongName' ; hand it a query name and it gives you the long name of the group, after which you can play around with its custom properties from a script : -- put revQueryLongName(tQueryName) into tQueryObject set the cREVDatabaseQuery[dbhost] of \ tQueryObject to the.other.host -- Oh, a little note of warning : do not try to place the database query groups onto a card, or the query will stop working alltogether. Took me a while to figure that one out... Hope this helped, Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder
Hahaha, Thanks for the warning Jan, will give it a try! Ton From: Jan Schenkel [EMAIL PROTECTED] Reply-To: How to use Revolution [EMAIL PROTECTED] Date: Fri, 5 Dec 2003 07:03:52 -0800 (PST) To: How to use Revolution [EMAIL PROTECTED] Subject: Re: Database Query Builder --- [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Question... When using the Database Query Builder, you have to enter the address of the database. But is there a way to create a preference-file which is loaded during startup, because I?m creating a mySQL-front-end which uses different databases (development db on server 1 and live db on server 2). Now I created my SQL-statements myself, so I check a preference-file at startup, which I manually can edit, or edit in my preference-tab in the program, but I would like to use the Database Query Builder and still be able to change and save these settings. Anyone any advice, because I can?t seem to find where the Database Query Builder gets and stores its data. Thanks in advance, Ton Kuypers Hi Ton, The revDatabase implementation is an interesting one, in that each and every query is actually an unplaced, empty group. The connection information for the query is stored in its custom property set named cREVDatabaseQuery : - cREVDatabaseQuery[dbtype] - cREVDatabaseQuery[dbhost] - cREVDatabaseQuery[dbdatabase] - cREVDatabaseQuery[dbport] - cREVDatabaseQuery[dbuser] - cREVDatabaseQuery[dbpassword] - cREVDatabaseQuery[dbssl] In order to get the actual group, you have to use the undocumented function 'revQueryLongName' ; hand it a query name and it gives you the long name of the group, after which you can play around with its custom properties from a script : -- put revQueryLongName(tQueryName) into tQueryObject set the cREVDatabaseQuery[dbhost] of \ tQueryObject to the.other.host -- Oh, a little note of warning : do not try to place the database query groups onto a card, or the query will stop working alltogether. Took me a while to figure that one out... Hope this helped, Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder: workaround please
On Thursday 13 November 2003 3:47 pm, you wrote: On the Database Query Builder, Record Set Tab, SQL query field: 1) enter some syntactically bad SQL 2) click the refresh query button (or close the Database Query Builder window) 3) now Rev gets stuck in an endless loop of modal error dialogs. OK The handlers appear to be identical, though I have not stepped through as yet. However it is clear that on Linux and 2.0.1, the behaviour is not so extreme as you have reported, no matter what sort of garbage I enter in the query field. By the way, I did not say three times , but three times for each db object, though I did not figure out how that observation could be true. Does the query builder work for you, if you enter syntactically correct sql? If so, why not debug the query outside the query builder for the timebeing?Moreover, queries that attach to field objects, generally, are not very sophisticated : maybe an inner join between client_id from invoice and client tables for example, in order to show the client name, or select detail rows corresponding to an invoice. The Query Builder is clearly designed to return a record view of each row. In the end, I am not sure that the by field/column interrogation of the db is going to be fast enough though showall fields seem pretty quick. ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder: workaround please
On Nov 13, 2003, at 12:56 AM, David Wilkinson wrote: This behaviour is observable in 2.0.1, although perhaps not as severely. My experience is that there appear to be three iterations of the query loop, and they are repeated for each object on the card that is attached to the query. Each iteration produces the error message. FWIW, deleting the query seems to fix the problem here. David, I think you are talking about something else. What I am seeing is a bug. A GUI bug, and doesn't have anything to do with the query loop going for 3 iterations. On the Database Query Builder, Record Set Tab, SQL query field: 1) enter some syntactically bad SQL 2) click the refresh query button (or close the Database Query Builder window) 3) now Rev gets stuck in an endless loop of modal error dialogs. The problem is this code in revDBQuerySetup stack / recordSet card. The SQL is evaluated, causing a modal error dialog, causing the keyboard focus to leave the field, then reenter it the field. Then another closeField fires, another modal error dialog. Endlessly. on closefield put the cActiveQuery of this stack into tActiveQuery put revQueryLongName(tActiveQuery) into tObjects revSetSQLOfQuery tObjects,the text of me if revCursorOfQuery(tObjects) is not empty then revUpdateRecordSourceDetails else set the label of button cREVDatabaseQuery[primarykey] to None disable button cREVDatabaseQuery[primarykey] end if end closefield So Runrev- the Database Query builder is effectively useless. How about a fix? I can't just comment out the handler, because then the query is not evaluated at all. Alex Rice [EMAIL PROTECTED] | Mindlube Software | http://mindlube.com what a waste of thumbs that are opposable to make machines that are disposable -Ani DiFranco ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder: workaround please
Le mer 12/11/2003 06:35, Alex Rice a crit : The same difficulties under Linux and Jaguar there... On Nov 11, 2003, at 10:19 PM, Alex Rice wrote: I can't believe I'm the only one being hassled by this bug, so is there a workaround I am missing? And I mean other than *not using the query builder at all*. It is appealing to use the GUI to maintain connections and recordsets, and doing scripting only where necessary. Alex Rice [EMAIL PROTECTED] | Mindlube Software | http://mindlube.com what a waste of thumbs that are opposable to make machines that are disposable -Ani DiFranco ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution -- Bien cordialement, Pierre Sahores 100, rue de Paris F - 77140 Nemours [EMAIL PROTECTED] GSM: +33 6 03 95 77 70 Pro: +33 1 41 60 52 68 Dom: +33 1 64 45 05 33 Fax: +33 1 64 45 05 33 Inspection acadmique de Seine-Saint-Denis Applications et SGBD ACID SQL (WEB et PGI) Penser et produire delta de productivit ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Database Query Builder: workaround please
I can't believe I'm the only one being hassled by this bug, so is there a workaround I am missing? In the Database Query Builder, Record Set tab, if you enter some bad SQL into the field labeled SQL Query:, a popup error message says An error resulted for the SQL command in the database You click OK, then SQL Query field gets focus for a moment, then loses focus and the same modal error message pops up. Repeatedly. Now I've tried Command-period and I've tried to turn off the Messages using the Messages toolbar item, but neither has any effect because Rev is stuck in this loop of modal dialogs. So - I have to force-quit Revolution? See bugzilla #696. This bug was opened 7 weeks ago. Alex Rice [EMAIL PROTECTED] | Mindlube Software | http://mindlube.com what a waste of thumbs that are opposable to make machines that are disposable -Ani DiFranco ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder: workaround please
On Nov 11, 2003, at 10:19 PM, Alex Rice wrote: I can't believe I'm the only one being hassled by this bug, so is there a workaround I am missing? And I mean other than *not using the query builder at all*. It is appealing to use the GUI to maintain connections and recordsets, and doing scripting only where necessary. Alex Rice [EMAIL PROTECTED] | Mindlube Software | http://mindlube.com what a waste of thumbs that are opposable to make machines that are disposable -Ani DiFranco ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: About mixing Database Query Builder with normal database library calls.
--- Andre Garzia [EMAIL PROTECTED] wrote: Hi Folks, I have a couple doubts that revGurus our there might clear. I am creating a simple app to manage a couple MySQL tables. Its the common tasks (insertion, modification, deletion), to navigate the database I am using Database Query Builder, filling fields with the data and some buttons to navigate. But I cannot use Query Builder to insert a Record can I? How can I identify what is the current record (so that i can disable the previous and next buttons when they reach the limits)? Cheers Andre Alves Garzia 2003 BRAZIL http://www.soapdog.org Hi Andre, You can execute any query (INSERT, DELETE, ...) on the database an existing query connects to, by means of the following command : revExecuteWithQuery name of the existing query, query to execute Example : put UPDATE customers SET something=123456 ; into \ tSQLQuery revExecuteWithQuery MyCustomerQuery, tSQLQuery -- As for checking if the current record is the first or last of the cursor corresponding to a query, use : revDBQueryIsBOF(name of the query revDBQueryIsEOF(name of the query -- If you want to learn more of the hidden features of the database query manager and its linked fields and buttons : - open the message box - use the button at the top of the window to go the Frontscripts section - click on the checkbox Show Revolution UI frontscripts to hilite it - in the list above, you'll see a line 'revDatabase' - double-click it, or select and click the 'Edit this script' button at the bottom right Note that it requires a good knowledge of the RevDB commands and functions, and familiarity with the message path and how frontScripts intervene. Hope this helped, Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: using database query builder
--- rand valentine [EMAIL PROTECTED] wrote: I have several questions about working with Rev and databases (I'm using Valentina xcmd for now on a mac running os 10.2.6). 1. When I open my main working stack, I have a Database Query Builder (hereafter DBQB) connection that connects to a Valentina database that presently has two tables, BasicLexicon and Keys. I have two queries, one for the table BasicLexicon and one for the table Keys. When I run revopendatabases() I get the answer: 4 Why not 1, 2, or 3? Why 4 for the database ID? It doesn't matter if I quit Runrev, turn off my computer, etc. I always get 4. It's an internal, unique number ; nothing to worry about, heh ; it just references the right connection info for its other functions if you want to make direct calls using the revDB functions. 2. In DBQB, I set a certain field as the primary field for a given query. But whenever I recheck the query, the primary field is listed as None until I click the refresh query button. Why would this be? If it's the same when you click the refresh button, there's nothing to worry about, and it probably has to do with the moment the connection is opened - when the stack opens or when the card opens ; it will only display this info once the query has been executed/refreshed once. 3. Previously I reported that I was able to use revDataFromQuery to get the results of a join, that is, request data from two distinct tables and have it stitched together. But now this no longer works -- when I execute the revDataFromQuery using the command that worked before, I get: revdberr, and that's all. Any ideas on what's going on? Also, if I can't do a join in this way, how _do_ I do one? It ought to work, but are you sure that's the entire error ? Usually, it's followed by an explanation. Have you tried : get revDataFromQuery(...) if char 1 to 6 of it i revdberr then answer it I'm sure it's just a small thing, that can be resolved with a bit of fiddling. Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Database Query Builder?
I am building a standalone Revolution frontend application for a MySQL database. I would like to use the Database Query Builder to build the queries and connect the various fields. I have a good handle on how to use the Database Query Builder and to set everything up. The problem is how do I allow the user to change the database connection information built by the Database Query Builder in a standalone? The user will have to change the Host, User, and Password to match their needs. Is there a way to use the revOpenDatabase to open the database ID that will be used by the query build by the Database Query Builder? Any suggestions or assistance would be appreciated. Thanks. ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder?
--- Marvin Wurth [EMAIL PROTECTED] wrote: I am building a standalone Revolution frontend application for a MySQL database. I would like to use the Database Query Builder to build the queries and connect the various fields. I have a good handle on how to use the Database Query Builder and to set everything up. The problem is how do I allow the user to change the database connection information built by the Database Query Builder in a standalone? The user will have to change the Host, User, and Password to match their needs. Is there a way to use the revOpenDatabase to open the database ID that will be used by the query build by the Database Query Builder? Any suggestions or assistance would be appreciated. Thanks. Hi Marvin, Here's the deal : the connection details are stored per query ; so you'll have to iterate over the queries, change the connection details and update everything. Code snippet : on UpdateAllDBConnections pDBType, pDBHost, pDBDatabase, pDBPort, pDBUser, pDBPassword put revQueryObjects() into tQueryObjects repeat for each line tQuery in tQueryObjects Update1DBConnection tObject, pDBType, pDBHost, pDBDatabase, pDBPort, pDBUser, pDBPassword end repeat end UpdateAllDBConnections on Update1DBConnection pObject, pDBType, pDBHost, pDBDatabase, pDBPort, pDBUser, pDBPassword set the cREVDatabaseQuery[dbtype] of pObject to pDBType set the cREVDatabaseQuery[dbhost] of pObject to pDBHost set the cREVDatabaseQuery[dbdatabase] of pObject to pDBDatabase set the cREVDatabaseQuery[dbport] of pObject to pDBPort set the cREVDatabaseQuery[dbuser] of pObject to pDBUser set the cREVDatabaseQuery[dbpassword] of pObject to pDBPassword revConnectQuery pObject revRefreshQuery pObject end Update1DBConnection Hope this helped, Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
using database query builder
I have several questions about working with Rev and databases (I'm using Valentina xcmd for now on a mac running os 10.2.6). 1. When I open my main working stack, I have a Database Query Builder (hereafter DBQB) connection that connects to a Valentina database that presently has two tables, BasicLexicon and Keys. I have two queries, one for the table BasicLexicon and one for the table Keys. When I run revopendatabases() I get the answer: 4 Why not 1, 2, or 3? Why 4 for the database ID? It doesn't matter if I quit Runrev, turn off my computer, etc. I always get 4. 2. In DBQB, I set a certain field as the primary field for a given query. But whenever I recheck the query, the primary field is listed as None until I click the refresh query button. Why would this be? 3. Previously I reported that I was able to use revDataFromQuery to get the results of a join, that is, request data from two distinct tables and have it stitched together. But now this no longer works -- when I execute the revDataFromQuery using the command that worked before, I get: revdberr, and that's all. Any ideas on what's going on? Also, if I can't do a join in this way, how _do_ I do one? Thanks so much. rand valentine ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution