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