var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help on Resolving a Pervasive Error.
When I try to execute a very large SQL statement I get the following error:
"SQL statement is too long. Maximum length is <nnn> characters."
Is there any configuration option in PCC or in ODBC Administrator to increase the maximum buffer of the SQL query.
Re: Help on Resolving a Pervasive Error.
At this time, It's not possible to stretch the max SQL statement size beyond 64K since these buffers are sized using a UINT16.
I know of no current plans to extend this limit. But if you contact our support folks and explain your requirements, they will forward your suggestions to the people who are planning future releases.
Large SQL Statement
I have a 37K OPENQUERY sql statement I'm running through SQL 2000 that fails when the number of OR conditionals is too high. The syntax is correct becuase it runs when a lessor number of OR conditions are chosen. Any suggestions? While the statement is below the documented 64K limit it still fails.
Thanks in advance.
Make sure you're running the latest HotFIx for 2000i. I remember hearing about a problem with 37 OR conditionals in a query.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
I do not answer questions by email. Please post on the forum.