GET-statement with or without VIA option.

RessingM@unive.nl RessingM@unive.nl
Wed, 13 Feb 2002 10:04:05 +0100


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