Building data base aps with Rev (Jan Schenkel)
janschenkel at yahoo.com
Tue May 20 05:24:01 CDT 2003
--- Sadhunathan Nadesan <sadhu at castandcrew.com> wrote:
> | If you wanted to go the 'non-scripting way', I can
> | have a look at it tomorrow ; don't have my
> | computer with me this evening.
> Yes, for sure, I'd be interested in that too.
> Again, wow! Many thanks. I don't know about stuff
> portal fields and custom props but you have given
> so many
> clues that, I am going to enjoy figuring it out.
> Gee, this is really wonderful of you.
As promised, I had a look at how to accomplish the
same thing without (too much) scripting. Here's what I
- use the query builder to create the same query twice
(otherwise you get refresh issues) ; name them
PortalQuery and DetailQuery
SELECT * FROM locations ;
- now create a new field and make it a table object ;
use the database panel to hook it up to the
PortalQuery and for columns pick "Show all"
- now create the other fields and uise the database
panel to hook them up to DetailQuery and pick the
- to round it all off, you'll want to update the
DetailQuery fields whenever you select a different
line in the PortalQuery table field ; so set its
script to (as usual, watch for wrappings):
put the hilitedLines of me into tNumber
put the cREVDatabase["queryobject"] of fld
"DetailField1" into tObject
put revQueryLongName(tObject) into tObject
if exists(tObject) and the
cREVGeneral["databasequeryobject"] of tObject is true
then send "revGoToRecordOfQuery" && tObject & comma &
- of course you'll have to employ in your PortalQuery
field the tricks I mentioned earlier to get the
Hope this helped,
"As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld)
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
More information about the use-livecode