Hi,
is there an option to modify the maximal string size that can be selected with embedded SQL Select?
At the moment there is a limit of about 32000.
This is my workaround at the moment (dw_syntax can be larger than 32k):
selectblob dwsyntax into :lb_dwsyntax from sp....() using sqlca;
ls_dwsyntax = string(lb_dwsyntax,EncodingAnsi!)
This dont't work with more that 32k size, but would be the better solution:
select dwsyntax into :ls_dwsyntaxfrom sp....() using sqlca;
Thanks
Regards Tobi
we are using SQL Anywhere as DBMS.
I read the Help for PBMaxTextSize. The Connection Option is for "SNC SQL Native Client for Microsoft SQL Server".
Is there a solution for SAP SQL Anywhere too?
Thanks
Regards Tobi
I cannot be sure, bu I seem to remember that we needed to add this setting to PB's ODBC INI control file. I the current case, PBODB170.ini in the SQL Anywhere section.
Regards ... Chris