It seems to me that what you want to do may be in the too hard basket.
I created a table called U2 that looks like:
DICT U2 11:27:33am 20 Feb 2009 Page 1
Field......... Type & Field....... Conversion.. Column......... Output
Depth &
Name.......... Field. Definition... Code........ Heading........ Format
Assoc..
Number
@ID D 0 U2
10L S
STATUS D 1 Status 1L
M LAYER
STAT.DATE D 2 D4/ Status Date 10R M
LAYER
LAYER PH STATUS
STAT.DATE
4 records listed.
And it contains:-
LIST U2 LAYER 11:29:30am 20 Feb 2009 PAGE 1
U2........ Status Status Date
R1 A 19/02/2009
B
C 19/02/2009
R2 B 19/02/2009
C
R3 B
C 19/02/2009
3 records listed.
(Sorry about wiggly columns)
I tried:
SELECT U2 WHEN (STATUS="B" AND STAT.DATE="")
but it selects ALL 3 records which is not what I expected unless the
associated MVs are not associated in the SELECT process. So I cleared the
selected list.
I tried:
LIST U2 WHEN (STATUS="B" AND STAT.DATE="") LAYER
and that listed the first and last records as I expected. So, my conclusion
is that the LIST command uses the association but the SELECT does not. Is
there a way to get the SELECT to respect the association? Or is this only
resolved through programming a UniBasic executable?
Jef.
--
View this message in context:
http://www.nabble.com/Need-help-with-SELECT-limiting-MV-tp22063800p22113739.html
Sent from the U2 - Users mailing list archive at Nabble.com.
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
