Information to locate a Numeric Overflow Record

CAFAM Administration, Set-up Users, Control Files, Repair Files etc
Locked
TechTeam
Posts: 175
Joined: Sun Feb 28, 2021 7:28 am

Information to locate a Numeric Overflow Record

Post by TechTeam »

From time to time you may experience an Internal error "Numeric Overflow - Data has been lost". The reason for this Numeric overflow error is due to some incorrect entry in one of the records in the Database being accessed. The incorrect entry will be in a field that holds numerical data and has become corrupted with a series of asterisks. Asterisks in the Data Field gets created due to a value entered that has inadvertently exceeded the width of the field limit and then causes this error. Usually a division by zero is the culprit. The only way forward once you experience this is it

(a) identify which Data file has these Asterisks
(b) locate the offending record, and
(c) replace it with a the correct value or even just a zero "0" i.e. a real number

To identify which record is causing this problem, try to print the file in question from the "Print Reports" so that the offending record is printed on the Screen within a report. Look for a series of asterisks "*****" in one of the Data fields. Once established, access this record from one of the Edit functions in the Program and change the value to the correct figure or enter a zero if appropriate.

You could also try and use the DBF database editor in Utilities (Repair Data in File) to access the file directly and change this value correctly. The attached screen shots show you how to do this

See the attached for details
Attachments
Locate Numeric Overflow Record.pdf
(192.22 KiB) Downloaded 858 times
Locked