Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    8

    Unanswered: 460: Statement length exceeds maximum.

    I've been getting this error for my excessively long SQL statements.

    Does anyone know what the row limit is? Does it vary from system to system?

    Since I am (mostly) making criteria statements on every line, could I shorten the number of rows by putting more than one criteria statement per line?

    That is

    Code:
    select blah.colors from blah
    where colors are in ("blue",
    "red",
    "yellow",
    "purple",
    "green",
    "orange",
    "muave",
    "tangerine")
    to :

    Code:
    select blah.colors from blah
    where colors are in ("blue",
    "red",
    "yellow", "purple",
    "green", "orange",
    "muave", "tangerine")
    (You will have to imagine that my list is very long)

    Will this work or Must I break it up?

  2. #2
    Join Date
    Jan 2007
    Posts
    8
    Well, I can't increase the number of lines by doubling them on the line. The same error occurs.

Posting Permissions

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