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.
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
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.
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)]