Hi,

I'm facing an issue while running the reports in WebFocus.

The error description is as below:

(FOC1400) SQLCODE IS 1 (HEX: 00000001)
: [S1090] [DataDirect][ODBC lib] Invalid string or buffer length
L (FOC1405) SQL PREPARE ERROR.

I'm using Teradata as the databse and it appears the issue occurs due to more values in the where clause of the query. I'm using direct SQL in my code. The query does run fine when I directly run it in database. I'm getting the error only when I try to run the query from WebFocus. Anyway to handle this?

Thank you very much!

Regards
Prasanna
WF 717

Perhaps you could post the QL code that is getting the error.