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
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
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