Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error: Data would be truncated
Message
De
30/06/2006 08:39:20
Jim Winter
Jim Winter Consulting
Hinesburg, Vermont, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Error: Data would be truncated
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01133038
Message ID:
01133038
Vues:
64
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform