Here is the fix for your problem if you still prefer to write ODBC reports:
Summary: ODBC Value exceeding max length or precision
Book: Support Solutions
Page: 7069MPS
PROBLEM DESCRIPTION: This error or a similar error occur while using the DataDirect ODBC drive to pull information out of V8.00 to another program.
Database Connector Error: 'HY000:[DataDirect] [ODBC OPENEDGE drive] [OPENEDGE] Column <FieldName> in table PUB.<TableName> has value exceeding its max length or precision. [Database Vendor Code: -210012]'
PROBLEM RESOLUTION: The problem stems from a field within the Data Dictionary titled "SQL Width". This field can be set from 0 to 31995. The error occurs when there are more characters within the data field than what the SQL Width value is for. This typically occurs for fields that contain large descriptions or comments. Example: PartDesc, Comments, LineDesc, etc.
STEPS to Correct:
=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=-=--=-
Notes:
- The following steps should be done from the Server, with everyone logged out of Vantage.
- The syntax below is for V8.00. For V8.03 and OE 10.0B or OE 10.1B, adjust the syntax accordingly.
1. Go Start->Programs->Open Edge 10.0B->Data Dictionary.
2. Right-click on the Data Dictionary and choose Properties.
3. Add a -rx to the end of the Target line.
4. In the Dictionary Startup window, choose Connect to an Existing Database and click OK.
5. For the Physical Name, type mfgsys and click Options.
6. Choose Network TCP, check the Multiple Users box, put in you V8.00 server for Host Name, put in the port number of you database for Service Name (the default is 8000), and click OK.
7. In the Tables column, search for the table referenced in the error message. Highlight it and click the Fields button above.
8. In the Fields column, search for the field reference in the error message. Highlight it.
7. Go to the top of the window and select Options->Adjust Field Width.
10. Double click into the "Width" column on the Field which is causing the error.
11. Change the value to a number higher than the number of characters you have in the field or just use the maximum value of 31995.
12. Click [OK] and save the updates.
13. Close and exit the Data Dictionary.
14. Repeat the process that generated the error message.
15. Remove the -rx from the Target of the Data Dictionary Properties.
Summary: ODBC Value exceeding max length or precision
Book: Support Solutions
Page: 7069MPS
PROBLEM DESCRIPTION: This error or a similar error occur while using the DataDirect ODBC drive to pull information out of V8.00 to another program.
Database Connector Error: 'HY000:[DataDirect] [ODBC OPENEDGE drive] [OPENEDGE] Column <FieldName> in table PUB.<TableName> has value exceeding its max length or precision. [Database Vendor Code: -210012]'
PROBLEM RESOLUTION: The problem stems from a field within the Data Dictionary titled "SQL Width". This field can be set from 0 to 31995. The error occurs when there are more characters within the data field than what the SQL Width value is for. This typically occurs for fields that contain large descriptions or comments. Example: PartDesc, Comments, LineDesc, etc.
STEPS to Correct:
=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=-=--=-
Notes:
- The following steps should be done from the Server, with everyone logged out of Vantage.
- The syntax below is for V8.00. For V8.03 and OE 10.0B or OE 10.1B, adjust the syntax accordingly.
1. Go Start->Programs->Open Edge 10.0B->Data Dictionary.
2. Right-click on the Data Dictionary and choose Properties.
3. Add a -rx to the end of the Target line.
4. In the Dictionary Startup window, choose Connect to an Existing Database and click OK.
5. For the Physical Name, type mfgsys and click Options.
6. Choose Network TCP, check the Multiple Users box, put in you V8.00 server for Host Name, put in the port number of you database for Service Name (the default is 8000), and click OK.
7. In the Tables column, search for the table referenced in the error message. Highlight it and click the Fields button above.
8. In the Fields column, search for the field reference in the error message. Highlight it.
7. Go to the top of the window and select Options->Adjust Field Width.
10. Double click into the "Width" column on the Field which is causing the error.
11. Change the value to a number higher than the number of characters you have in the field or just use the maximum value of 31995.
12. Click [OK] and save the updates.
13. Close and exit the Data Dictionary.
14. Repeat the process that generated the error message.
15. Remove the -rx from the Target of the Data Dictionary Properties.
--- In vantage@yahoogroups.com, "VantageUser13" <vantageuser13@...> wrote:
>
> I have a report for read on the table hdcase. When I execute the reports, doesn't work, because I have this error message : column in table %s has value exceeding its max length or precision. My problem is the field hdcase.description, is too long. How to resolve my problem, in Crystal report, if possible to appear this field, when is too long ?
>
> thanks
>
> vantage 8.03.408b
>