Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP is not capable to run even simple select statements
Message
From
27/01/2002 15:35:44
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
VFP is not capable to run even simple select statements
Miscellaneous
Thread ID:
00611298
Message ID:
00611298
Views:
55
The following simple code produces error

SQL expression is to complex (VFP7 SP 1)

Help says: Visual FoxPro ran out of memory ....

I have 256 MB RAM. Why vfp is not capable to run this simple select ?
CREATE CURSOR alloweditems ( liik c(10))
CREATE CURSOR artliik ( liik c(1))
CREATE CURSOR toode ( f1 c(1))
SYS(3055,2040)
select * ;
   from toode ;
      left OUTER JOIN artliik ; 
        ON .f. ;
   where .t. OR ;
  (.f. AND artliik.liik in (select * from alloweditems ) )
Andrus
Next
Reply
Map
View

Click here to load this message in the networking platform