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
