Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Icetips Article
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 21, 2024, 3:44 am This article has been viewed 35238 times.
|
|