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 - techsupp...@rfcsystems.com Internet Support - websupp...@rfcsystems.com All Other Requests - requ...@rfcsystems.com --------------------------------------------------------- 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: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, August 07, 2012 4:33 PM To: profoxt...@leafe.com 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: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Weller Sent: Tuesday, August 07, 2012 4:22 PM To: profoxt...@leafe.com 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: ProFox@leafe.com 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/DF1EEF11E586A64FB54A97F22A8BD04420D88E087C@ACKBWDDQH1.artfact.local ** 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.
