screw up?

[Michael Lee]

Hello Pablo et al,

I think that QTP or QUIZ would have a problem with this. What you have is the
equivelant of having an ACCESS statement with several files that have the same
item name. How would you differentiate between the items in this case of the
ACCESS statement? Easy-you say ITEM COMPANY-NAME OF FILE A (or B or C). How do
you do it in the case of it being in one file? Not so easy.

I think the preferred method would be to rename the items that occur more than
once (COMPANY-NAME1, COMPANY-NAME2, etc.) if it's possible. If this is a smaller
part of a redefined item and for some reason changing the dictonary is not an
option the only other thing I can think of is to create a large TEMP (or a DEFINE
in QUIZ) and concatenate all the field values together and move that TEMP into
the larger field.


Michael Lee
MCL Systems Inc.


"Paul (Pablo) Grim" wrote:

> Hi listers,
>
> I recently defined a new record structure for electronic W2 reporting to
> Social Security.
>
> The record structure has 4 or 5 fields that are duplicated.  That is; the
> same data goes on the record twice for each of these fields.  At least for
> my organization.  Other orgs could report different data in these fields
> which is why they are available.
>
> 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.
>
> thanks
>
> p
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" 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.