Add LONG DataTypes support for scalar functions

Status
Not open for further replies.
N

NR

Guest
Trying to use scalar functions on a WLOGNVARCHAR data type returns an error: select substring(column,1,10) from table; The following error information describes the failure ODBC Call = SQLExecute() SQL State = HY000 Native error = 10190(27CE) Error Message = [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engi ne]Invalid input to scalar function SUBSTRINGW(). Elapsed time 440338 ms. Elapsed time: Prepare 94234 ms. Execute 592 ms. Fetch results 345512 ms And in a log file we see the following: SQLDRV : [TID: 2DC]:[Wed Feb 05 09:12:53.840 2014] damapi.c:6508: Conversion of data from type:-10 to type:-8 is not supported. SQLDRV : [TID: 2DC]:[Wed Feb 05 09:12:53.840 2014] sqlfunc.c:394: Invalid input to scalar function SUBSTRINGW(). SQLDRV : [TID: 2DC]:[Wed Feb 05 09:12:53.840 2014] sqlutil.c:1915: Scalar function:substring returned error.

Continue reading...
 
Status
Not open for further replies.
Top