Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link Par2: Error: String data, right truncating 1999-08-09 -- Rick Hoffman Run the MSSQL Trace (with all options turned on), as soon as you get the error open
up the Text file and look at the data log. It will show the files / fields being accessed.
Today I ran accross the error with a text field in SQL. All I did is put the name of the
field in the EXTERNALNAME field property in the dictionary. This corrected the problem.
"Error show below".
Also do the following.
1. Create a new dictionary.
2. Use the Dictionary Synchronizer and import the SQL tables in question.
Check all fields and keys, make sure they all match to the dictionary in question.
3. Make sure your keys have the following settings. (Case Sensitive "turned > on"
and Exclude Empty Keys "turned off"). This is also very important....
Warning: 01S01[Microsoft][ODBC SQL Server Driver]Error in row
Error Occurred: 01004[Microsoft][ODBC SQL Server Driver]String data, right
truncation NEXT(VIEW:35F304:dbo.Letters 3) File Error: String data, right truncation
Time Taken: 0.02 secs
LET:LETTERNAME : ''
LET:LETTERDESCRIPTION: ''
LET:LETTERTYPE : ''
LET:CONTENTS : ''
Today is November 23, 2024, 2:22 am This article has been viewed 35242 times.
|
|