> From: Wjhonson > I'm assuming that a file you want to read into a Pick system, with > embedded MM.MM dollars is coming from an outside source. I can't > recall ever seeing 12.2 used for 12.20 outside of a Pick system.
This is weird, I've seen a few discussions within the last week where people can't tell the difference between data storage format and rendering or transport format. With regard to: > I can't recall ever seeing 12.2 used for 12.20 outside of a Pick system. I have news for you - they ALL do. Other systems don't store data with trailing zeros because they have no need to store them. It's up to each individual user/application to decide whether to use 1 digit, 2, 4, or none. Data is stored with as few characters as possible, which is part of the reason why we tend to store integer-only in MV. Our system of storing integers with implied 4 digit precision is flawed and archaic, but we all live with it, except where apps have been written where the author was unaware of such conventions. When importing data we can expect to see just about anything. The format is determined by accepted convention and is largely unimportant. Most applications use classes to define their data types, whether Integer, Float, Decimal, or Currency. When discussing data transfers the discussion usually includes "how do you want your numbers?". To that I generally respond, "I don't care, whatever works for you, just document it and keep it consistent". If they say Integer, I mask it as required. If they mask it, I convert to integer. If they want to send a dollar amount, it's usually sent with two decimals as an output format, but since we all know it's just data, it's not unreasonable to expect dollar figures with 0 or 1 decimal. In other words, there are no conventions - we make it up with each project and site, following app-specific standards as possible. T _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
