vfp9 Limits

[mccartmd]

Hi: looooking for limits of visual fox. . .
have read them in the past. . . . .get old I guess. . .now I can't find them. . .any direction to find them is appreciated.
( . . .looking for what is the # of SQL joins a person can make into a cursor. . .)
THX
M

 

[bborissov]

Check Visual FoxPro System Capacities in HELP

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[Dan Freeman]

VFP9's motto was "no limits". Many were removed (such as array sizes).

There USED to be a limit of 9 joins (I think, or maybe that was UNIONs), but that was lifted. This may or may not be in the help topic mentioned, but that topic is always the place to start.

Note that "number of joins" is not the only limit that might come into play. You can be within the allowed number of joins and still have code that exceeds the complexity the compiler can handle, particularly in &macro expansion situations.

Are you getting an error?

 

[Mike Lewis]

Up to VFP 8.0, there was limit of nine joins, nine subqueries and nine unions. All those limits were lifted in VFP 9.0.

Of course, a single SELECT statement is also subject to the 8K limit on a command, but it's hard to imagine anyone approaching that.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business