screw up?

[Chris Sharman]

>So, when I defined the record, I entered the same item names more than
once.
>I'm realizing this is probably grossly unnormalized data, but in a way it
>makes sense because it really is the same data more than once on a given
>record.

>My question is how does Powerhouse deal with this in qtp?   eg:  if I have
>an item COMPANY-NAME on the record twice and I want to do an ITEM
>COMPANY-NAME INITIAL "ABC CORP" what will happen?  Will both fields get
>assigned this value, or just the first one?  (seems to be the case in my
>experiments).  It actually seems somewhat unpredictable depending on how I
>code it.

The item name should always resolve to the first occurrence in the record.
There should be no way to refer to subsequent occurrences from PH.
This should mean that the subsequent occurrences are always given initial
values (space or zero unless you've specified otherwise).
That all applies to dictionary records/files. Subfiles are slightly
different, in that after they've been created you can add records to them
containing any data in any order, provided only that the overall record
length matches. The original field names are retained & used when you access
the data.

If you're getting 'unpredictable' results, that's quite odd. Do post more
detail here, and/or take it up with support.

Chris



-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.