Data would be truncated error

[judyscofield]

I'm getting a 'String or Binary Data Would be Truncated' error when running my code. I have an .addnew command, then fill some fields, and then an .update command. I've tried putting values into the fields that I know are smaller than the field lengths.

Other posts have advised to add SET ANSI_WARNINGS OFF. I added that line to my code and get a compile syntax error on that line. Can anyone help?

 

[dbtech]

Can you post the code?

do you still want to insert values into the fields, knowing that the value inserted exceeds the field length?

if you are using VB, then it has be set at the Connection level example cn.excute("SET ANSI_WARNINGS OFF&quot

Example
create table #temp(Yourname char(10))

--This Works
SET SET ANSI_WARNINGS OFF
insert into #temp values('12345678901')
SET SET ANSI_WARNINGS ON

--This Fails (The default setting in SQL Server)
SET SET ANSI_WARNINGS ON
insert into #temp values('12345678901')
SET SET ANSI_WARNINGS OFF

SELECT * FROM #temp
go
drop table #temp




dbtech

 

[judyscofield]

No I really don't want to post anything that's too long. After further investigation, I discovered that a default value was causing the error, not any of the strings I was trying to insert. Thanks for your help. Judy.