Not millions: 1102 needed to be hand-done; took about 2 weeks. Now changing programs which generate dictionaries. Grrrr
On 24 January 2011 21:02, Symeon Breen <syme...@gmail.com> wrote: > 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 > -- 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