Not sure if this would work in UV or not, but in mvBase you can stick the dict into the MD and use it for any file. See entry *A1 below:
*A1 001 A 002 1 003 Attr. 1 004 005 006 007 008 009 L 010 15 If that doesn't work, you could try the not very well known 'USING DICT' phrase, like: LIST TEMP USING DICT ALL.FIELDS F1 F2 F3 hth, Allen E. Elwood www.tortillafc.com Quality Code Since 1978 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Tuesday, October 10, 2006 10:34 To: 'u2-users@listserver.u2ug.org' Subject: [U2] Bad DICTionary Attributes I would like to see what is in field 8 for several data dictionaries. I need a command like... LIST DICT INVOICE WITH <FIELD 8> LIKE "M" but I need help with syntax on the <Field 8> part. Now that I am writing this e-Mail, I suppose that I could write a little UniBasic program. We have a bug here where it looks like somebody put an "M" into field 8 in several dictionaries. UniVerse v8.x does not seem to care, UniVerse v10.1 comes back with error messages like... UniVerse/SQL: Conversion "MD3," is incompatible with an INTEGER datatype The burden is that I have to wade through all the dictionary items with an MD3 characteristic (sometimes there dozens). Once I fix the "MD3" item, it may come back with... UniVerse/SQL: Conversion "MD1," is incompatible with an INTEGER datatype Then, I start over. Both I-Descriptors and D-Descriptors appear to exhibit the problem. There is also a lot of stuff in fields 9 thru say 14 of many of these dictionaries. It is not clear to me why these attributes are populated. Further suggestions would be appreciated. --Bill ------- 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/