Kbase P51618: Problems passing parameters to a C program using ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/11/2003 |
|
Status: Unverified
SYMPTOM(s):
[ODBC PROGRESS driver]String data, right truncated. Error in parameter 1.
Query prepare does not return results with an ODBC SQL-92 connection.
CAUSE:
External parameters in DOS are sent to the program as strings and fields are of numeric type.
FIX:
It is necessary that the numeric fields in the WHERE clause in the query compare against the same data type. Use the function CONVERT("STRING",<field-name>) for all the numeric values, or convert external parameters to numeric.