Weeks ? you must have millions of them ;)
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: 24 January 2011 04:23 To: U2 Users List Subject: Re: [U2] 3.99 x 3 = 11 Hi Dan, Yes, I do realise we could change our system to use only I-type dicts, with F1 value 1 for some data, value 2 for another, etc, etc. Pretty untidy. As you say, it would be a huge job. We still could not assign a field to use for stamps, complying with the rest of the system. We now list and inquire on dictionaries through programs which present them all in the same format. We are in the process of changing all dictionary items which calculate on quantity to I-types. Annoying, but achievable in weeks, rather than months. Thanks, Kate On 24 January 2011 15:42, Dan McGrath <dmc...@imb.com.au> wrote: > 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 > -- 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 _____ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1191 / Virus Database: 1435/3398 - Release Date: 01/23/11 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users