Re: Access97 problems with Informix Online 7.12 and I-CLI 2.5

william@carsinfo.com (William Harris) wrote: :In article <339C7EFC.76C2@nospam.bridge.bellsouth.com>, :heather.chipka@nospam.bridge.bellsouth.com says... :>> - DECIMAL becomes a Text string :>This is not correct. It should become Number(Double) I am not sure of :>your problem here. : :Given what a decimal type is (an almost abitrary precision number), I can see :why Microsoft might choose to represent it as a text field instead of a :number. I don't think an Access "number" could handle a DECIMAL (31,5), for :example. It should of course have been currency in Access for decimal types up to 4 digits after the decimal point. That is the max the currency datatype can handle. To read decimal data into a Double in Access which is a binary floating point type gives rounding errors which may be devastating in several types of applications. This is but one small problem with MS Access that is the reason why we don't use it for development, only for add hoc queries and some reporting. This same problem exist in Visual Basic as well, and any user should be very aware of it. 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