What are you trying to say here? You don't make sense (sorry). Not knowing UD, I have to be careful here, but if I'm selecting BY.EXP a multi-value field, I would NOT expect the number of records selected to be the same as the number of items in the select list.
I'm getting the impression that @SYSTEM.RETURN.CODE *IS* the number of records selected. Thing is, you're asking it to count records multiple times if the same record appears multiple times in the select list. Let's say we have 10 records, half of them with two items in an MV field, and the rest with just one. Am I correct in thinking that, if you do a SELECT BY.EXP, the @SYSTEM.RETURN.CODE is 10, the number of *records* selected, while SYSTEM(11) is 15, the number of *items* in the select list? Hope this clarifies things :-) Cheers, Wol -----Original Message----- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: 26 June 2007 14:24 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly To David A. Green, who said, "SYSTEM(11) returns number of items in the active select list. I think we should leave the @SYSTEM.RETURN.CODE as the number of records selected." @SYSTEM.RETURN.CODE is NOT the number of records selected. That is the problem. It is the number of records queried/polled, not the number of items returned in the select list. Those numbers will not be the same for a multivalued attribute or if the attribute is null and UDT.OPTION 59 is ON. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
