Re: [U2] Regarding: LISTING SUB-VALUES
"David A. Green" <[email protected]>
| Newsgroups | gmane.comp.db.u2.general |
|---|---|
| Message-ID | <000b01cf030e$51f5ea50$f5e1bef0$@com> |
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. Green (480) 201-7953 DAG Consulting -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Shanmukh Nandha Sent: Thursday, December 26, 2013 11:26 PM To: [email protected] Subject: [U2] Regarding: LISTING SUB-VALUES Hi Everyone, Always a pleasure to read the useful advice and varying personalities on this list. Generally we are using SB+ account. There will be many multi-value field available in files, How to list specific Multi values of a field in specific file . For example:- 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. 123454ý 655656ý 767787ý 87887 (Cust Ph No with Multi value) General to list specific field we use LIST CUSTOMER F3. How to list 3rd position of 3rd field of CUSTOMER file. Could any one of you can please let me know Thank you, Shan _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users