On 6/30/06, Jim Winter <jimw (AT) proadv D.O.T com> wrote: > 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> . >
You don't mention your version of FoxPro. Earlier versions had trouble with Unicode fields where lengths were returned in bytes, which are twice the number of characters allowed in the fields. Take a look at the SQL Server structure definitions and see if this might be the cause.
-- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
©2006 Ted Roche |