Hi Kate, You can use multivalue and sub-multivalue marks can be used to keep it just as organised.
:ED.... :P 001: DýMANDýENUM CLASSES 002: 10 003: 004: 005: 10L 006: M :EV :P 001: D 002: MAND 003: ENUM CLASSES We normally just use LISTDICT (an inbuilt paragraph) to display dictionary items :LISTDICT ourfile SORT DICT ourfile TYP LOC CONV MNAME FORMAT SM ASSOC BY TYP BY LOC BY @I D 13:38:56 24 JAN 2011 1 @ID............ TYP LOC.......... CONV MNAME.......... FORMAT SM ASSOC..... CLASS D 10 10L M I can appreciate that it can be an enormous task to change an existing system though. Regards, Dan -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: Monday, 24 January 2011 12:19 PM To: U2 Users List Subject: Re: [U2] 3.99 x 3 = 11 Hi Dan, Thanks for your suggestion. Yes, we use that space for the short description of the data. It would be very messy to try to use this additionally for: - before cell, after cell processing flags - minimum characters - store data field no - data required flag - display-only flag - max no of sets (assuming use F7 to define set this data belongs to, and that item for each item in the set with different type) - match patterns list - delimiter and sub-field no, if applicable - sundry code ID for validation - prompt ID for search - update stamps list (same format as other files: each with date, time, function, who) Especially when it all works appended to A and S type dicts - would take weeks or months to change! What happens on UniData if you ED and P, or print an I-type dict item? Do you stay viable? Cheers, Kate On 21 January 2011 18:06, Dan McGrath <dmc...@imb.com.au> wrote: > With I-types, are you aware you can store whatever you want in Attribute 1 > after the data type? > > This is where we store any additional information required as such data > integrity checks, date last changed, etc. > > Log out issues with dictionary compilation must be specific to UniVerse (?) > as we do not have that issue in UniData. > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate > Stanton > Sent: Friday, 21 January 2011 3:46 PM > To: U2 Users List > Subject: [U2] 3.99 x 3 = 11 > > Does anyone else have a problem with this? > > We have (for about 30 years) allowed users to use a decimal point when > entering quantity. > > In the dim dark past (was it under Prime or Ultimate? don't remember) we > discovered that correlatives ignored anything after a decimal point, so wrote > horrible correlatives multiplying the bit before the point by 10000, > appending 0000 to the bit after, taking the first 4 chars of this and adding > it, doing arithmetic then dividing result by 10000. > > In the slightly less dim dark past (before 1997, when we introduced our > current change control system), we noticed that this problem had been fixed, > and removed the complication from correlatives involving quantity. > > Now, many years and much development later, we extensively use > dictionary output rather than programs for reports, forms (eg > invoices) and queries. > > Inaccurate data is an unexpected result. On type S (or A) dictionaries, > result of calculation in A or F correlatives is truncated to the decimal > point (eg 3.99 x 3 = 11). Minor result is incorrect figures. Major result is > under-reporting of totals which are not able to be reconciled to General > Ledger (eg value of stock on hand). > > Rocket's response is that the manual says correlatives only do integer > arithmetic. This is not quite true, as integer 3.99 x 3 would be 9. > > I-type dictionary items handle the data correctly (3.99 x 3 = 11.97). > > I-types have their own problems, in that fields after 10 are used for > internal purposes, so are not able to carry extra information needed for data > entry (such as data required, display only, validation rules, data change > stamp, etc. > > I-types also are hard to work with as using a changed dictionary without > compiling the dictionary logs the user out, and inadvertent attempt to > display data in fields beyond F10 can lock user up, as well as untidily > logging out. > > We are asking Rocket to consider this a bug. > > What do you think? > > TIA, Kate > > Kate Stanton > Walstan Systems Ltd > 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand > Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 > Email: k...@walstan.com > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ______________________________________________________________________ > This email has been scanned by the MessageLabs Email Security System. > For more information please visit http://www.messagelabs.com/email > ______________________________________________________________________ > ###################################################################### > ##################### The information transmitted in this message and > attachments (if any) is intended only for the person or entity to > which it is addressed. The message may contain confidential and/or > privileged material. Any review, retransmission, dissemination or > other use of or taking of any action in reliance upon this information > by persons or entities other than the intended recipient is > prohibited. If you received this in error, please contact the sender and > delete the material from any computer. > > The intended recipient of this e-mail may only use, reproduce, > disclose or distribute the information contained in this e-mail and any > attached files with the permission of IMB. > ###################################################################### > ##################### _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 Email: k...@walstan.com _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ########################################################################################### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ########################################################################################### _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
