Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2003
    Posts
    9

    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.

  2. #2
    Join Date
    Jun 2003
    Posts
    1

    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.

  3. #3
    Join Date
    Feb 2003
    Posts
    9
    Thnx jchapman... ;-)

  4. #4
    Join Date
    Mar 2004
    Location
    KC,USA
    Posts
    1

    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.
    Shawn

  5. #5
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Make sure you're running the latest HotFIx for 2000i. I remember hearing about a problem with 37 OR conditionals in a query.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •