Powerhouse 4GL RDBMS Question - Subitems

[Bill D Michael]

And just to make things worse, you can't use a trigger at the database
level to populate "extra" fields in the record; we tried setting it up like
this:

X        CHAR(10)
; former Subitems of X
subitem1 CHAR(3)
subitem2 CHAR(3)
subitem3 CHAR(4)

with a trigger to move the first 3 chars of X into subitem1, next 3 to
subitem2, and last 4 to subitem3 on update.  (Or the reverse; build X from
the subitems.) You get a "record has been changed since you found it" error
if you do an update stay, change something else, and try to update again,
because Oracle has changed the record on the table, but PH still has the
"old" image in it's buffer, and they don't match on the pre-update re-read.
We wound up putting the code in every applicable screen at preupdate to
build X from the subitems before the update. (And QTPs in a similar way.)

Cognos _could_ do subitems entirely in the dictionary/language, and "fake
out" the database, but that'd be extra effort...

Bill

------------------
"This posting reflects the individual views and opinions of the author and
does not necessarily represent the views and opinions of International
Paper."



                                                                                                   
                      "Brian Schalme"                                                              
                      <bschalme@airspee        To:       powerh-l@lists.swau.edu                   
                      d.mb.ca>                 cc:       (bcc: Bill D Michael/WoodProd/IPAPER)     
                      Sent by:                 Subject:  Re: Powerhouse 4GL RDBMS Question -       
                      powerh-l-admin@cu         Subitems                                           
                      be.swau.edu                                                                  
                                                                                                   
                                                                                                   
                      09/25/2003 09:48                                                             
                      AM                                                                           
                                                                                                   
                                                                                                   




             This is true. PowerHouse gets the schema information directly
from the
database (such as Oracle). All you can do is specify default formatting
and edit information with the ELEMENT statement.

                         Brian Schalme
                         Airspeed Consulting
                         http://www.airspeed.ca


Charles Finley wrote:

> With IMAGE DB you can define Subitems in Powerhouse which is nothing else
as
> using one single field out of the database and defining a data structure
> within Powerhouse for this single DB field using the PHD (Powerhouse
> Dictonary).
>
> Example:
>      Field in IMAGE DB:      X CHAR(10)
>      Subitems in Powerhouse using field X of IMAGE DB:
>                        subitem1 CHAR(3)
>                        subitem2 CHAR(3)
>                        subitem3 CHAR(4)
>
> We are speaking with someone who has  told us that they have tried to do
> this with a relational DB and learned that is under the impression that
> Powerhouse does not support this ability to overlay fields   for a
> relational DB, only for IMAGE DB. The client went on to say that you
cannot
> define Subitems in the Powerhouse Dictonary for a relational DB.
>
> Can someone confirm this?
>
> Charles Finley
> Transformix Computer Corporation
> (760)-439-3146
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
>


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