L
Looch
Hi All,
I originally wrote a sproc with one of the parameters set as
SqlDBType.nvarchar,8. The parameter in the sproc was defined as 8
cahracters and the column in the table was also set to nvarchar, 8. I
changed all three to allow for a 15 character long entry but the
entries from the text box i'm using are truncated to 8 characters when
the sproc is called. I've seen the "data will be truncated the
procedure will fail.." error when the length is mismatched but not in
this case. Seems pretty straigh forward but what am I missing? I've
been through the code and sproc a hundred times and can't sem to find
anything.
thanks
I originally wrote a sproc with one of the parameters set as
SqlDBType.nvarchar,8. The parameter in the sproc was defined as 8
cahracters and the column in the table was also set to nvarchar, 8. I
changed all three to allow for a 15 character long entry but the
entries from the text box i'm using are truncated to 8 characters when
the sproc is called. I've seen the "data will be truncated the
procedure will fail.." error when the length is mismatched but not in
this case. Seems pretty straigh forward but what am I missing? I've
been through the code and sproc a hundred times and can't sem to find
anything.
thanks