| Author |
Topic |
|
Limuh
Yak Posting Veteran
94 Posts |
 Posted - 2008-02-15 : 03:57:07
|
String or binary data would be truncated.The statement has been terminated.-- i got this message what it suppose to mean? Thanks Please help.. |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-02-15 : 04:09:53
|
| are you trying to update a column with a value that is longer than the data type? i.e. you have a char(10) and your trying to update it to a value that's 11 characters long?Em |
 |
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2008-02-15 : 04:42:49
|
| no. i do have a char(5) and if i update the date it will incremented by 1. e.i if the count from my table today is 1 and tommorow the table will also give me the data who is like the previous table the count will be incremented by one so the count will be 2.. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-15 : 04:46:00
|
| Please post your table structure and code which you are having problem with, to get the clear understanding of the problem.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-02-15 : 04:46:32
|
| nope, it's no use. i've read your answer 6 times and still don't understand what you mean. come again?Em |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-15 : 04:57:37
|
| Why numeric columns like Amt and Count are defined as char? and what is the structure of tbl_CLR_Delinquency table?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-02-15 : 04:58:03
|
| why are all your 'counts' char rather than int?Em |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-15 : 05:04:14
|
| Account Number and Cardmember Act No are differing in size.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2008-02-15 : 05:08:04
|
| so i need to change the size equal to one another? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-15 : 05:11:39
|
| Not necessarily if all data in Cardmember Act No column is <= 20 chars.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2008-02-15 : 05:14:12
|
| String or binary data would be truncated.The statement has been terminated-- how can i resolve this problem? |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-02-15 : 05:29:25
|
| the error is telling you that youare trying to put more than 20 characters in the that column. so yes, make them both 50Em |
|
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2008-02-15 : 05:32:49
|
| Posted - 02/15/2008 : 05:29:25 -------------------------------------------------------------------------------- the error is telling you that youare trying to put more than 20 characters in the that column. so yes, make them both 50Em thank you very much..:) Have a nice day |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2008-02-19 : 03:03:24
|
| thanks |
|
|
|
|
Terminated Update Script