Cannot Save Form Data

Classic Servoy
1

Hi all

I need some help with an error message

Cannot save form data

com.servoy.j2db.dataprocessing.DataException: JZ00B: Numeric overflow.

I need to know what this means so that I can fix it.

Help is greatly appreciated.

Tom

2

that sounds like you are saving a number that is way to big for the field in the database.

3

Thanks Johann

So what is the largest integer you can have.

I have an integerlike this: ‘2010021610101’

Thanks for your help

4

if it is stored as a 32bit integer then: 4294967296 or 2147483648 depending if it is signed or not
so yours is to big

5

Thanks

Is this a change from 3.5? The reason I ask is that it was never a problem. Trying to port to 5.1 has raised some issues. Is there documentation for these differences?

6

Tom

Can you check what the underlying database column type is?

When upgrading from 3.5 did you use the same database instance or did you start with an empty db and had Servoy created the tables?

Rob

7

Thanks Rob

Sorry I could not get back sooner.

Here is the history. I have a 3.5 solution that has been in successful operation for 2+ years. The process in question is concerning a couple of columns that are typed “number” in Servoy and have a length of 8(default). Column A named “donation_number” in the table “donations” , column B named “donation_number” in the table “donation_detail” and column C named “detail_number” in table “donation_detail”. Columns A & B contain the same data with a numerical value similar to the following; “20091231102” Column C stores a numerical value of “2009123110201”. Processing these numbers is flawless. Simple math works great. After further testing, attempts to export to text result in numbers such as this; "2.0091231102E10 which renders the number unusable. So I converted the number to text and exported to text with success.

Trying to Import this into a 5.1 equivalent always throws the error;

Cannot save form data

com.servoy.j2db.dataprocessing.DataException: JZ00B: Numeric overflow.

It appears to me that I have some anomaly or at least something that I do not understand.

Thanks for the help.

8

tommygill:
After further testing, attempts to export to text result in numbers such as this; "2.0091231102E10 which renders the number unusable. So I converted the number to text and exported to text with success.

So you changed the datatype of the underlying table to text?
Does the database that you are importing into already have these columns? If they do I am sure they are numeric otherwise you would not get the numeric overflow.

If this is the case then dropping these tables may help as the column definitions do not match.

Rob

9

Sorry Rob. Been a busy week.

No data types were changed. I only made a calculation to display the number as text and exported that. I guess the basic question is why during the process of exporting to a text file the number, which in its original form was “20091231102”, changes. When I open the exported file with a text editor the exported number is “2.0091231102E10”.