Database Query Builder

tkuypers at pandora.be tkuypers at pandora.be
Mon Dec 8 17:20:40 EST 2003


Tnx Jan,
This works!

> From: Jan Schenkel <janschenkel at yahoo.com>
> Reply-To: How to use Revolution <use-revolution at lists.runrev.com>
> Date: Sat, 6 Dec 2003 03:13:33 -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:
>> Jan,
>> 
>> It's not working, I don't think I understand how to
>> use this... :(
>> When I setup a databse-connection and use
>>   put revQueryLongName(cREVDatabaseQuery["dbhost"])
>> into msg
>> I don't get anything...
>> 
>> What am I doing wrong?
>> 
>> Ton
>> 
> 
> Hi Ton,
> 
> Maybe the following is a better example. Suppose you
> have a query named "MyFirstQuery".
> --
> put revQueryLongName("MyFirstQuery") into \
>     tQueryObject
> put the cREVDatabaseQuery["dbhost"] of tQueryObject
> --
> 
> For a list of all your query objects, use the
> undocumented function 'revQueryObjects'
> 
> So if you only want a quick way to change the host for
> all your queries, you can do something like :
> --
> put <_the_new_host_> into tNewHost
> put revQueryObjects() into tQueryObjects
> repeat for each line tQueryObject in tQueryObjects
>   set the cREVDatabaseQuery["dbhost"] of \
>       tQueryObject to tNewHost
> end repeat
> --
> 
> 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
> 
> 



More information about the Use-livecode mailing list