Re: Ad-hoc Report Writers -Reply
Posted in 1997
"Reiner Kunz" <Reiner.Kunz@pr-kunz2.M.eunet.de> wrote: :I also tried using Accss97 with I-CLI, but had *BIG* problems with = :DECIMAL/MONEY types 'cause Access converts them to text strings. They = :seem to be too long for normal access number types What is your = :experience with Openlink and these datatypes? How does Openlink handle = :them? In my case with OpenLink they become double presision floating point numbers. That's better than text, but still a problem if you are conserned about rounding errors. They should have become currency datatype in Access if the number of digits after the decimal point was 4 or less and double presision floating point otherwise Access have no "decimal" datatype with more than 4 digits after the decimal point. One of Microsofts greater stupidities. I haven't taken this up with OpenLink yet. I have however copied this post to them. If something can be done about this I am sure they will. :--=20 :cu Reiner (munich, germany) : :Peter Tashkoff <TASHKOP@kiwi.co.nz> schrieb im Beitrag = :<5o9pfo$3p6@cssun.mathcs.emory.edu>... :> MSAccess is what we use in house. It is pretty :> hard to beat as a report writer both for application :> reports (Allows menus and programming), and :> End-User reporting (Has macros and a query :> builder). Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org