Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error: Data would be truncated
Message
From
30/06/2006 08:39:20
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Error: Data would be truncated
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01133038
Message ID:
01133038
Views:
63
Getting the message 'String or binary data would be truncated.' when I try to save an updated remote view back to SQL Server.

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
Next
Reply
Map
View

Click here to load this message in the networking platform