SQL Joins/filters view limitations

[mccartmd]

Hi:
Does VFP9 have a limitation on the number of joins that can set in a sql view? and does it make a difference whether the join is inner, left, right, full or cross to any limitation? . . .also, is there a limitation on number of filters that can be set in a view?
Thank you for your feedback.
Mike

 

[Mike Lewis]

Mike,

I've never heard of such a limit -- other than the usual limit on command length, of course.

(If a limit does exist, I'll bet Tamar knows what it is.)

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[pthalacker]

From the Help File:

There is no limit on the number of joins per SELECT statement.

pamela

 

[mccartmd]

Thank you Pamela and Mike, you are true professionals!
To Pamela. . .such a concept to look in the help files.!
I had looked there but could not find till I dug deeper and have found the following and thought I would share:

"Visual FoxPro 9.0 removes the limit on number of UNION clauses in a SQL SELECT statement. The previous limit was nine."

"Visual FoxPro 9.0 removes the limit on the number of tables and aliases referenced in a SQL SELECT statement. The previous limit was 30."

These are listed under the search of "SQL Improvements"

Thanks again!
Mike