Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Visual FoxPro
Expertise: Beginner
May 2, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Maximum length of SQL

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.

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.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date