Thanks Jan I did exactly the same. I made a new database and table using the SQLite demo stack. I also did a clean install and re-entered my serial number etc to see if there was something wrong with RunRev. I would like to further eliminate any possibility or user error. Could you send me a screen shot of the window in RunRev for the database query builder correctly filled out for SQLite. Also I am using GLX2 maybe I should eliminate that? I am on OS X 10.4.11
Bill On Sat, Apr 5, 2008 at 2:10 AM, Jan Schenkel <[EMAIL PROTECTED]> wrote: > --- william humphrey <[EMAIL PROTECTED]> wrote: > > I re-installed RunRev from scratch. I tested SQLite > > using the demo stack and > > found that it works fine. I tried the database query > > builder (using that > > same test stack) and absolutely no joy. Why is the > > database query builder > > included in RunRev if it cannot be made to work? > > It is meant to be for ease of use? > > > > I have tried every possible parameter of connection > > in the little database > > query builder window (including those that work in > > earlier versions of > > RunRev) and nothing works. > > > > Has anybody else gotten database query builder to > > work in RunRev 2.9? > > > > Perhaps there is a pref file somewhere that I need t > > delete? > > > > This is really extremely frustrating especially when > > you consider that the > > database query builder is meant to be for "ease of > > use". > > > > I wish I had never ever used the database query > > builder in any of my stacks. > > Now it looks like I should re-write everything > > ignoring that menace. > > > > > > Hi William, > > I just fired up Rev 2.9 and created an SQLite database > from scratch, using the Query Builder to create the > database and connect to it, and a single button to > create a table in that database in 2 lines of script; > when I switch to the 'Record Set' tab in the query > builder, I can see the new table I just created, and > query it. > > So that would seem to work quite well. Let's see if we > can figure out why it won't connect for you. Where > exactly is the database file located? Was it created > with Revolution or have you modified it using another > SQLite tool? > > 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) > > > > > ____________________________________________________________________________________ > You rock. That's why Blockbuster's offering you one month of Blockbuster > Total Access, No Cost. > http://tc.deals.yahoo.com/tc/blockbuster/text5.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 > -- 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