devxlogo

Maximum length of SQL

Maximum length of SQL

Question:
Is there a maximaum length of an SQL program? I have used the query designer in Visual Foxpro 3.0 with many lines of criteria. When I try to run it I get the following error message:

SQL: Statement too long.

If I take out a few lines of criteria, it works. Why would they make a limit on the length of an SQL routine? I even tried to use the “Program” mode and got the same error.

Answer:
The important piece of information when working with large SQL statements in Visual FoxPro is the length of the compiled length of the WHERE clause. There is no way to judge the compiled length from the actual SQL statement: I have seen developers parse the SQL and run several smaller SQL statements that use the result of the previous SQL statements, but this can only occur under controlled circumstances.

Visual FoxPro 6 has a SYS() function that extends this limit.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist