Getting the message 'String or binary data would be truncated.' when I try
to save an updated remote view back to SQL Server
<http://www.microsoft.com/sql> .
Only one field in the view is set to Updateable and that field is defined as
decimal (15,2) in SQL Server. The view, as initially set in ViewEditor, had
the field defined as N(17,2). I changed it to N(15,2) and still got the
error. I also tried N(10,2) and, after Del Lee pointed out that SQL Server
doesn't count the decimal in the length of the field, N(16,2). In all cases
I get the same error and the table isn't updated.
Can anyone suggest what else I should be checking?
TIA,
Jim
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
©2006 Jim Winter |
