Re: [U2] Regarding: LISTING SUB-VALUES

2013-12-27 Thread Wols Lists
On 27/12/13 06:25, Shanmukh Nandha wrote: CUSTOMER FILE contains fields like 1. CUSTOMER.NAME http://customer.name/ (single value) 2. CUSTOMER.SALARY (single value) 3.CUSTOMER.PHONE.NUMBER (multi value) 1. JOHN (Cust name with single value) 2. 70$/hr (Cust salary with single value) 3.

Re: [U2] Regarding: LISTING SUB-VALUES

2013-12-27 Thread Charles Stevenson
Anthony meant: 002: CUSTOMER.PHONE.NUMBER1,3 On 12/27/2013 1:08 PM, Wols Lists wrote: CUSTOMER.PHONE.NUMBER.3 0001: I 0002: CUSTOMER.PHONE.NUMBER3 1,3 extracts the 3rd value from that single attribute. 3 extracts the 3rd attribute, which in this case would yield null. CUSTOMER.PHONE.NUMBER

Re: [U2] Regarding: LISTING SUB-VALUES

2013-12-27 Thread David A. Green
Shan is CUSTOMER.PHONE.NUMBER an associated MV? If you have an association with a field like CUSTOMER.PHONE.TYPE and you want just the FAX numbers then you can use the WITH keyword in your query like: :LIST CUSTOMER CUSTOMER.NAME WHEN CUSTOMER.PHONE.TYPE EQ FAX CUSTOMER.PHONE.NUMBER David A.

Re: [U2] Regarding: LISTING SUB-VALUES

2013-12-27 Thread Will Johnson
Or @RECORD3,3 I wonder if using the @Record in this way, would be a microsecond faster than using CUSTOMER.PHONE.NUMBER ? It would seem like the processor would have one less step to do, but maybe I'm wrong. -Original Message- From: Charles Stevenson-2 [via U2 (UniVerse UniData)]