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/