‎2007 Jun 13 2:24 AM
Hi,
I have a Z field in a Z table with the data type int2 and lenght 5. I created a table maintenace for this table. When I enter more than 3 digit number for this filed it is giving short dump while updating the data into the table.
Please suggest me.
Thanks,
Swamy
‎2007 Jun 13 2:30 AM
‎2007 Jun 13 2:46 AM
Hi,
The error text is
Data area for accessing table is too small.
The target area into which data from the database table is to be read
is too short.
Thanks,
Swamy
‎2007 Jun 13 3:01 AM
INT2
2-byte integer, value range from -32767 to 32767. Fields of this type should only be used as length fields. Such length fields are directly in front of the length field (type LCHR, LRAW). If there is an INSERT or UPDATE of the length field, the database interface enters the length actually used in the length field. The length is defined as 5 places for this data type.
the dump message is not referring INT2 as the cause of the problem.
‎2007 Jun 13 2:35 AM
hi,
i've checked some of the tables with fields of INT2 type...and i cant find any records having 3 digits...anyway can you put some more details about the dump
‎2007 Jun 13 2:42 AM
hi swamy,
i've created a ztable with zfield of INT2 type..and unlike what you said, i can put records from 1 - 5 digits...it would help us if you can put some more details about the dump.