Error : String or binary data would be truncated

[Pelson2003]

Here where i give support we run a software called Ideas for Windows ( IFW ).

We need to make some reports.. and when we try to make a report, we recieve this message:

Connect = ODBC;DSN=IFW2001;UID=SA;DATABASE=IFW2001
Flavor = 3
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. 8152[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. 3621ODBC--call failed. 3146
Query = UPDATE IFW2001..reports
SET Duration = '0h 0m 46s 19/03/2004 18:13:42'
WHERE ReportID = 'TB.BRL'


Anyone know what i have to do ?
We didnt have the support for this program anymore.

Need to resolve.

Thanks
Nelson

 

[ecobb]

The amount of information you're trying to enter into the database is more than that particular database column will allow. Don't type as much info, for example, try "Duration = '19/03/2004 18:13:42'" instead of "Duration = '0h 0m 46s 19/03/2004 18:13:42'"



Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

 

[Pelson2003]

But the problem is on IDEAS when I try to make a report.

Hummm

In this moment I am not trying to enter information , insert the information on database.

The problem is occuring when I try to get this information and make a report.

Is anything I can modify on SQL Database to resolve the problem.

Thanks
Nelson

 

[MakeItSo]

Sounds to me as if this SW had a field limitation (e.g. like Excel:
Perhaps your SW cannot handle field contents over 256/1024 characters and you are trying to report with a field that exceeds this limit, e.g. nvarchar (4000)...

Could this be the case?
Andy

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[Pelson2003]

What is SW.. yes i am trying to make a report to a excel file...

yes ... its possible to be this case my problem

Nelson

 

[MakeItSo]

hi Nelson,
SW is short for software:

we run a software called Ideas for Windows ( IFW ).

I thought this was some special SW and thus some strange format.

Excel will not allow more than 256 characters per cell / 1024(?) per merged cell.

I guess you need a workaround for that. Perhaps using Access instead of Excel could suffice.
Do you need your report in table-like format?
Do you have to be able to open it in Excel?

How many characters can your largest field contain? Perhaps you can split the cell values before/while transferring to excel. You could create a temporary table where you insert the field like this:
SELECT ....,substring(field1,1,len(field1)\2) as part1, substring(field1,len(part1)+1,len(field1)-len(part1))

You would have to play around with this statement until you get the desired results, but it might help...

Good luck,
MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[Pelson2003]

Man , my position is very complicated

1) I dont have access to IDEAS Program. I cant make the select.

Is there any way I cant solve this problem ,only using SQL Server ?

Sorry for the trouble.

Nelson

 

[tiver]

can you export the report in csv format then open it up in excel?