I was able to see (through an ODBC connection) an I-descriptor that displays only the first value of a multi-valued field without using a subroutine call.
Here is the DICT entry: I FIELD(SitusStreetNbr,@VM,1):' ':FIELD(SitusStreetName,@VM,1) Situs Address 50L S I could also use a standard I-descriptor to return the COUNT of values in a multi-value field - through an ODBC connection: I DCOUNT(SitusStreetName,@VM) + 0 MD0 SITUS COUNT S I concur with Garry Smith on the creation of a separate account with VOC entries pointing to production data, but maintaining a local DICT that is used solely for ODBC connections (minimize the work by choosing only the fields you need, and rename the DICT entries with names appropriate to the "outside" world). >>> "Garry Smith" <[EMAIL PROTECTED]> 7/29/2008 8:57 AM >>> You will need to create I-Descriptors that call subroutines to return single values. We have created a separate account that has VOC entries pointing back to the production data, and the dictionaries are just the fields we need for our ODBC application. One of those applications is the UPS WorldShip ODBC connection to our UV data. Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Katz Sent: Tuesday, July 29, 2008 7:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODC field association I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
