Database Query Builder

[tkuypers at pandora.be]

Hahaha,

Thanks for the warning Jan, will give it a try!

Ton

> From: Jan Schenkel <janschenkel at yahoo.com>
> Reply-To: How to use Revolution <use-revolution at lists.runrev.com>
> Date: Fri, 5 Dec 2003 07:03:52 -0800 (PST)
> To: How to use Revolution <use-revolution at lists.runrev.com>
> Subject: Re: Database Query Builder
> 
> --- "tkuypers at pandora.be" <tkuypers at pandora.be> 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
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
>