Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Strange overflow error
14 views
Skip to first unread message
Luigi Caselli
Jan 22, 2001, 5:27:18 PM1/22/01
to
In pdox 7 (16 bit) we've got this strange message "Overflow. The source data
is numerically too large (positive or negative) to store in the
destination". We have only very small values in numeric fields and the files
structures have no problems at all. Only a little scan loop getting values
from a source file and putting them in another one... (running for months
without any problems)
Any suggestions?
is numerically too large (positive or negative) to store in the
destination". We have only very small values in numeric fields and the files
structures have no problems at all. Only a little scan loop getting values
from a source file and putting them in another one... (running for months
without any problems)
Any suggestions?
Luigi Caselli
Dennis Santoro
Jan 22, 2001, 5:46:51 PM1/22/01
to
Are you using a small int field and trying to put a value outside the
approximately + or - 32,000 range which small ints can handle?
approximately + or - 32,000 range which small ints can handle?
Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
375 High Street
Rochester, MA 02770
(508) 295-7350
and
Waldweg 5
83512 Reitmehring
Germany
08071 924271
Providing solutions to health care, business, governments and non-profits since
1982
Luigi Caselli
Jan 24, 2001, 4:14:35 PM1/24/01
to
No. We're using only Number fields.
Luigi Caselli
Dennis Santoro <RDA...@RDAWorldWide.com> wrote in message
news:3A6CB85B...@RDAWorldWide.com...
Bertil Isberg
Jan 25, 2001, 4:02:55 PM1/25/01
to
Luigi
Add errorTrapping to your code to find out on which record this happens.
--
Bertil Isberg CTECH
read the newsgroup: corelsupport.faqs.paradox
for Frequently Asked Questions
---------------------------------------------------
Luigi Caselli <luigic...@iol.it> skrev i
diskussionsgruppsmeddelandet:3a6f4590@cnews...
Joseph Misko
Jan 25, 2001, 10:30:11 PM1/25/01
to
When you say "the files structures have no problems at all," does that mean
you ran a table repair or something comparable? If not, you want to start
there, we have had similar problems with number fields. In fact, we had to
export the table to text, clean up the bogus values, and reimport.
Hopefully, this is not your case, but you may want to examine the contents
of those number fields more. As a test, create a new table from scratch,
don't use anything from the old, and run your routine on the new table.
--
Joseph Misko
Just my format("E" + chr(36) + "L1,W.2", (number(chr(45) + chr(50)) / 100))
--
Luigi Caselli <luigic...@iol.it> wrote in message news:3a6cb39c@cnews...
you ran a table repair or something comparable? If not, you want to start
there, we have had similar problems with number fields. In fact, we had to
export the table to text, clean up the bogus values, and reimport.
Hopefully, this is not your case, but you may want to examine the contents
of those number fields more. As a test, create a new table from scratch,
don't use anything from the old, and run your routine on the new table.
--
Joseph Misko
Just my format("E" + chr(36) + "L1,W.2", (number(chr(45) + chr(50)) / 100))
--
Luigi Caselli <luigic...@iol.it> wrote in message news:3a6cb39c@cnews...
0 new messages