Question

[Joe Boyle]

I can only assume that you are short of reference manuals, and suggest you
go onto the Cognos web site and download the Acrobat PH books set, Acrobat
PHWeb books set or Acrobat Axiant books set. These are searchable PDF files
and make life very much easier than leafing through hard copy.

Regards, Joe.


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Philip Jackson
Sent: 17 March 2005 08:28
To: 'Connie S. Loveland'; powerh-l@lists.sowder.com
Subject: RE: Question

An example from one of our systems does what you are after.

In the screen, there is the primary file

FILE SOURCES &
 HTMLKEY SOURCE-ID

And a reference file

FILE COPY-CODES REFERENCE

Further down there is the field defined as

FIELD COPY-CODE OF SOURCES &
 DYNAMICLIST COPY-CODE OF COPY-CODES &
 DISPLAYING DESCRIPTION OF COPY-CODES &
 LOOKUP ON COPY-CODES &
  MESSAGE "This Copy Code is unknown" 

This results in a dynamic drop-down list of the descriptions of the copy
codes on the web page that shows the current one to the user as you require,
but also lets them choose another from the list.  No changes to the
corresponding .htm file are required.

It's actually pretty cool, because instead of having two fields - the code
and the description - as green-screen PowerHouse would normally show, this
is just has the description and looks like a 'real' web page.  You have to
make sure that your users set up the reference file with different
descriptions for each code though, because if they use the same description
for different codes, you can't tell them apart on the web page.

Cheers,
Philip.

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Connie S. Loveland
Sent: 16 March 2005 22:04
To: powerh-l@lists.sowder.com
Subject: Re: Question

We are using SQL Server and Powerhouse Web.

I believe a Windows drop-down list and Dynamic list are the same thing.  We
have a reference table which is where the data is stored.  We have another
table where information is passed.  We want the modify screen to allow the
user to first see what they originally picked from the reference table and
then be able to pick a different value from the reference table, which would
re-populate the other table.  In other words I am a user who pick ABC from
the drop down list.  I go back to that record and realize I made a mistake I
really wanted DEF, I want to pick DEF from the drop down list and store that
information for this record.

At 04:50 PM 3/16/2005, Philip Jackson wrote:
>Can you please specify what breed of machine and version of PowerHouse 
>you are using?  And what is your underlying database?
>
>When you say dynamic lists, is that like a Windows drop-down list? 
>PowerHouse Web does that very easily in quite a nifty way, and I seem 
>to remember that even green-screen PowerHouse does it (sort of) for 
>relational databases.
>
>There is also a way of calling a subscreen to list all the valid values 
>so the users can pick the one they want - useful for lists of codes 
>from a reference file, etc. Is this the type of thing you are looking for?
>
>Cheers,
>Philip
>
>----- Original Message ----- From: "Connie S. Loveland" 
><csloveland@washtrust.com>
>To: <powerh-l@lists.sowder.com>
>Sent: Wednesday, March 16, 2005 9:31 PM
>Subject: Question
>
>
>>We are new users to Powerhouse.  We have a page which uses dynamic 
>>lists to populate a master table.  We are trying to create the same 
>>page with modify capabilities where we would use a dynamic list that 
>>would first show the value that's populated in the master table then 
>>allow the user to pick a new value from the dynamic list.  Has anyone 
>>written any language that utilizes dynamic lists in this mannor?
>>
>>Thanks in advance for any assistance
>>Connie Loveland
>>
>>= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list: 
>>powerh-l@lists.sowder.com
>>Subscribe: "subscribe" in message body to 
>>powerh-l-request@lists.sowder.com
>>Unsubscribe: "unsubscribe <password>" in message body to 
>>powerh-l-request@lists.sowder.com
>>http://lists.sowder.com/mailman/listinfo/powerh-l
>>This list is closed, thus to post to the list you must be a subscriber.
>>---
>>[This E-mail was scanned for viruses for your protection]
>>
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list: 
>powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to 
>powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to 
>powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
---
[This E-mail was scanned for viruses for your protection]


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.