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 16:19:17
Zlatin Zlatev
Sofia, Bulgaria
 
 
To
27/01/2002 15:35:44
Andrus Moor
Tallinn, Estonia
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Re: VFP is not capable to run even simple select statements
Miscellaneous
Thread ID:
00611298
Message ID:
00611306
Views:
17

>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 ) )
>


What expression do you have in your ON clause?
try perefrasing the Where clause like the following - it is not exactly the same but, just a starting point (move some conditions in the ON clause)
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. AND (.t. OR .f.) Where artliik.liik in (select * from alloweditems )
Also you can try to split your query in two parts.

HTH
Zlatin Zlatev,
MCSD (VS6)

Make solutions, not programs!

Previous
Reply
Map
View

Click here to load this message in the networking platform