Thanks Fred and Richard. It was as I thought but you've confirmed it. I just could not remember!!
John Weller 01380 723235 07976 393631 > -----Original Message----- > From: [email protected] [mailto:profoxtech- > [email protected]] On Behalf Of Richard Kaye > Sent: 07 August 2012 21:37 > To: [email protected] > Subject: RE: Field Width > > You got me curious so I tried a few things and precision makes things even > stranger. > > CREATE CURSOR test (numfield n(6,2)) > SET DECIMALS TO 8 > Browse Normal > INSERT INTO test (numfield) VALUES (999.99) INSERT INTO test (numfield) > VALUES (-999.99) INSERT INTO test (numfield) VALUES (-999.99) INSERT INTO > test (numfield) VALUES (-999.98) INSERT INTO test (numfield) VALUES (- > 999.9) INSERT INTO test (numfield) VALUES (-999.99) INSERT INTO test > (numfield) VALUES (1000) INSERT INTO test (numfield) VALUES (10000) > INSERT INTO test (numfield) VALUES (100000) INSERT INTO test (numfield) > VALUES (1000000) > > I would have expected an error on the larger numbers. > > Richard Kaye > Vice President, Auction House Systems > Artfact/RFC Systems > Voice: 617.746.9838 > Fax: 617.746.9801 > > > For the fastest response time, please send your support queries to: > > Technical Support - [email protected] Internet Support - > [email protected] All Other Requests - [email protected] > > --------------------------------------------------------- > This message has been checked for viruses before sending. > --------------------------------------------------------- > The information transmitted is intended only for the person or entity to > which it is addressed and 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. > > > -----Original Message----- > From: [email protected] [mailto:profoxtech- > [email protected]] On Behalf Of Richard Kaye > Sent: Tuesday, August 07, 2012 4:33 PM > To: [email protected] > Subject: RE: Field Width > > I believe the 6 would include the decimal point so for positive values it should > be 999.99. > > -- > rk > > > -----Original Message----- > From: [email protected] [mailto:profoxtech- > [email protected]] On Behalf Of John Weller > Sent: Tuesday, August 07, 2012 4:22 PM > To: [email protected] > Subject: Field Width > > I'm having a senior moment! What is the maximum value a numeric field of > size 6,2 in a dbf can hold? Is it 9999.99 or 999.99 - in other words, do I have to > make an allowance for the decimal point? Also, if it is 9999.99 can it also hold > -9999.99? This is so fundamental that I can't find it in the Help file. > > Thanks > > John Weller > 01380 723235 > 07976 393631 > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
