This is a migrated thread and some comments may be shown as answers.

Error in passing a Date as parameter in Query designer

1 Answer 219 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
ranjith
Top achievements
Rank 1
ranjith asked on 25 Mar 2019, 03:30 AM

Hello,

I am trying to pass two date parameters to my query in Query designer but i getting below progress error

 

ERROR[22001][DataDirect][ODBC Progress Openedge Wire Protocol driver]String data, right truncated.Error in parameter 3.

Whereas it is working for other data types like character, integer and logical.kindly help me to resolve this issue

 

1 Answer, 1 is accepted

Sort by
0
Silviya
Telerik team
answered on 27 Mar 2019, 03:25 PM
Hello Ranjith,

What is the currently installed version of ODBC Oracle Wire Protocol? I researched and found out that this is a common issue. Please check the following articles and the resolutions provided (likely it is a bug which is already fixed in the next version of the product):
SQL: ERROR "STRING DATA, RIGHT TRUNCATED. ERROR IN PARAMETER 2" EXECUTING AN INSERT STATEMENT.
"STRING DATA, RIGHT TRUNCATED" ERROR WHEN SELECTING DATE FIELD
OPENEDGE 10.2B ODBC DRIVER RETURNS ERROR "STRING DATA, RIGHT TRUNCATED. ERROR IN PARAMETER 1" WHEN PARAMETER VALUE EXCEEDS SQL WIDTH

Best Regards,
Silviya
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Report Designer (standalone)
Asked by
ranjith
Top achievements
Rank 1
Answers by
Silviya
Telerik team
Share this question
or