update to 2.9? --
william humphrey
shoreagent at gmail.com
Sat Apr 5 14:38:22 EDT 2008
I couldn't bring myself to roll-back and am still beating my head against
the wall. I finally at least got the "there was an error connecting to the
database" message to show up when entering the information into the database
query builder. After hundreds of absolutely no result (except a crash or
two) no matter what I did that is an improvement.
I wish there were clear instructions on how this should be filled out. Even
the pop-up is a little odd as it flips to altsqlite when you choose SQLite.
There is also no indication of whether it only works with SQLite 3 or not.
I'm beginning to think there is some interesting stuff here to blog about.
Why are the beginning stages of database access always really difficult?
Think back to the early days of PHP and MySQL. The set-up was nearly always
full of pitfalls which made the initial learning curve very steep and
frustrating.
On Sat, Apr 5, 2008 at 11:42 AM, william humphrey <shoreagent at gmail.com>
wrote:
> I tried the database "TEST" with password example and user example and
> runrev.com as the host and Mysql chosen. Nothing happened (at least it
> didn't crash).
> I will now roll back to the earlier version of RunRev and see if I can
> rescue my work.
>
>
> On Sat, Apr 5, 2008 at 11:34 AM, william humphrey <shoreagent at gmail.com>
> wrote:
>
> > I tried connecting to a Valentina database using the query builder and
> > that crashed RunRev. All I did was point to it with "Host" using the "for
> > SQLite database only pointer tool" and then chose Valentina2 -- instant
> > repeatable crash every time. Since there are no instructions how to fill out
> > this window I think it should at least be crash proof for trial and error
> > people like me.
> >
> >
> > On Sat, Apr 5, 2008 at 10:21 AM, william humphrey <shoreagent at gmail.com>
> > wrote:
> >
> > > PS - I think the new user manuel should include such a screen shot
> > > too. The new manuel does not give any instructions at all for filling out a
> > > SQLite connection.
> > >
> > >
> > > On Sat, Apr 5, 2008 at 10:17 AM, william humphrey <
> > > shoreagent at gmail.com> wrote:
> > >
> > > > 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 <janschenkel at yahoo.com>
> > > > wrote:
> > > >
> > > > > --- william humphrey <shoreagent at gmail.com> 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 at lists.runrev.com
> > > > > Please visit this url to subscribe, unsubscribe and manage your
> > > > > subscription preferences:
> > > > > http://lists.runrev.com/mailman/listinfo/use-revolution
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > http://www.bluewatermaritime.com
> > > >
> > >
> > >
> > >
> > > --
> > > http://www.bluewatermaritime.com
> >
> >
> >
> >
> > --
> > http://www.bluewatermaritime.com
>
>
>
>
> --
> http://www.bluewatermaritime.com
>
--
http://www.bluewatermaritime.com
More information about the use-livecode
mailing list