Refresh Table after editing record in another stack - bumped

[william humphrey]

Thanks -- I remember your excellent stack. I originally copied it and used
MySQL. Now I'm using SQLite and thinking about Valentina. I used the
database query builder because I was able to copy the way 9 to 5 reports
used to work with the "set SQL of Query" function called by right clicking a
field thus being able to search on any field in the database quickly.
You are the third industry maven to tell me that the database query builder
was perhaps something I should move on from.

I like the idea of user friendly software (thus coming from hypercard) and
the database query builder is easy for me to understand. It also seems to be
supported and minor improvements made to it by RunRev. I don't like that it
is slow (now in version 2.9). I also don't like that no one else seems to
use it.

I think ease of use in a software development platform is really important.

On Mon, Apr 7, 2008 at 11:52 PM, Sarah Reichelt <sarah.reichelt at gmail.com>
wrote:

> If you turn on "Revolution UI Elements in Lists" in the VIew menu, you
> will be able to show the Revolution stacks in the Application Browser
> and edit their scripts directly. You will be able to check the scripts
> there and perhaps apply them.
>
> However I see what you mean about slow updates. Have you considered
> just using the database calls yourself and not using the query
> builder? I find that to be enormously faster, and once you get used to
> it, much simpler to maintain.
>
> If you want to try this out, you might like to start by having a look
> at my MySQL test stack at <http://www.troz.net/Rev/tutorials.php>.
>
> Cheers,
> Sarah
>
>
>
> On Tue, Apr 8, 2008 at 11:54 AM, william humphrey <shoreagent at gmail.com>
> wrote:
> > Thanks -- I hadn't realized that Mark was talking about his own handler.
> >
> >  The button which is "Refresh" for the database query builder is given
> it's
> >  ability in the database tab and the script is not visible. There are
> several
> >  interesting commands for the database query builder which are not
> documented
> >  anywhere. I was hoping someone knew the one for "refresh".
> >  Also I noticed that all the database functions in the new version of
> RunRev
> >  are much slower.
> >
> >  On Mon, Apr 7, 2008 at 4:22 PM, Sarah Reichelt <
> sarah.reichelt at gmail.com>
> >  wrote:
> >
> >
> >
> >  > On Tue, Apr 8, 2008 at 2:59 AM, william humphrey <
> shoreagent at gmail.com>
> >  > wrote:
> >  > > I have the same problem. I use the database query builder to fill
> out
> >  > fields
> >  > >  in my card and I would like to automate the "refresh" button's
> call. I
> >  > tried
> >  > >  sending mouseup to the "refresh" button and get no error but also
> >  > nothing
> >  > >  happens.
> >  > >  I tried  send "loadTable" to stack "Main Stack" and got the error:
> >  > >
> >  > >  Message execution error:
> >  > >
> >  > >  Error description: Handler: can't find handler
> >  > >
> >  > >
> >  > >  I can't find "loadTable" in the RunRev reference manuel either.
> >  >
> >  >
> >  > "loadTable" is the name of Mark's refresh handler,so unless you have
> >  > written one with the same name, it won't be found.
> >  >
> >  > If I am understanding you, there is a Refresh button which works, but
> >  > you can't call it automatically? Have a look in the script for the
> >  > Refresh button and see what it has in it. If it is all in a mouseUp
> >  > hander, you would be better separating it out into another handler
> >  > which could be called by the mouseUp and by your automatic updater
> >  > script.
> >  >
> >  > Sorry, but I don't use the database query builder, so I'm not sure
> >  > exactly what sort of scripts it produces.
> >  >
> >  > Sarah
> >  > _______________________________________________
> >  > 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
> >  _______________________________________________
> >  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
> >
> _______________________________________________
> 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