I don't think you get any errors on the insert, but you do lose your values. You'll actually get "*"'s in the field.
Interesting. In the browse, on the non-active row, they show as 9.E+7. VFP stores type N fields as character in the actual file. It's converted back and forth text/numeric as needed. At least that's what I remember about it. Fred On Tue, Aug 7, 2012 at 1:37 PM, Richard Kaye <[email protected]> wrote: > 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:[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:[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/cajcbksomu5mpf7-jnrzndv1jf2puko5hnpfpgonjacqt5wo...@mail.gmail.com ** 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.
