RE: CA Express data truncation error

[Dennis Munro <DMunro@xxxxxxxxxxxxxxxxxxxx>]

Sorry - I forgot that things would get cut from the e-mail on our end.  The
following is the error message I am getting:

FrmTestEntry + cmdSave_Click[IBM][Client Access Express ODBC Driver (32
bit)][DB2/400 SQL] Data truncated.

I am running CA Express V4R5M0.

Thanks - Dennis.

Dennis Munro

"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."  Dilbert's Words Of Wisdom:

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@badgerminingcorp.com
(920) 361-2388

-----Original Message-----
From: Dennis Munro [mailto:DMunro@badgerminingcorp.com]
Sent: Wednesday, January 30, 2002 11:42 AM
To: Midrange List (E-mail)
Subject: CA Express data truncation error

V4R5M0  -  1 cum/group ptf's behind  -  W2K  w/SP2 p/c

I am getting the following error when we increased the field size from 30 to
50 character for a 400 table that has a VB front end program.  The
application has other files that I can write data to but by changing the
field size of this one table, it aborts.



As soon as I change the field size back to 30, the program does not give us
this error.

I changed the field size to 60 & then 100 but to no avail - same problem.
Is there someplace where I can go to figure out which field is causing this
error?  There is no system message.  Or does data Truncated means something
other than the obvious?

Talked to the VB programmer & I've looked through the Express web page & all
the faq's I could find.  Why would recompiling the dds for the file with the
different field size cause a problem?  I looked at the DNS for the
connection & there is nothing there that I can see?????

Thanks - Dennis.

Dennis Munro

"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."  Dilbert's Words Of Wisdom:

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@badgerminingcorp.com
(920) 361-2388

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.