GET-statement with or without VIA option.

[Chris Sharman]

Yes, I think it should be the same.
I don't think there were any relevant issues in 7.10.F2.
What access statements have you got on the file ?
Please post output of
Qshow> sho rec des1_gedd037z
as well as the quick file statement, access statements, field statement,
and which procedure you're in.
GET can conflict with lookup clauses during input/edit processing - if this
is the case you're better with another file "alias other open 1".

Chris
-----Original Message-----
From: ressingm@unive.nl [mailto:ressingm@unive.nl]
Sent: 13 February 2002 09:18
To: mx% powerh-l@lists.swau.edu
Subject: GET-statement with or without VIA option.


Hello,

I have a question about using the VIA option on a GET-statement in Quick. In
most cases I use only the VIAINDEX and the USING options to define a get
statement. For example:

GET DES1_GEDD037Z &
  VIAINDEX GEDD037A &
  USING    ENUPLC OF GEDD037Z, &
           TNUENDRMNT &
  OPTIONAL

But this statement doesn't always retrieve the correct record and the
problem is solved by adding the VIA option:

GET DES1_GEDD037Z &
  VIAINDEX GEDD037A &
  VIA      ENUPLC, ENUENDRMNT &
  USING    ENUPLC OF GEDD037Z, &
           TNUENDRMNT &
  OPTIONAL

In my opinion both constructions should work identical (both using the same
index-fields), but they don't, according to my test results.
Does anyone have a suggestion what causes the difference ?

Additional information:
PowerHouse version 7.10.F2
Platform: OpenVMS 7.1 (DEC-Alpha)
File-type: RMS, indexed

Greetings,

Martie Ressing
Univé Verzekeringen
Zwolle, The Netherlands

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
----------------------------------------------------------------------------
----
Date: Wed, 13 Feb 2002 10:04:05 +0100



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

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.