Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: Bert Murillo
  Where is Bert Murillo?
 Valenzuela
 Philippines
 Bert Murillo
 Tags
Subject: RE: How to make a Matrix
Thread ID: 104494 Message ID: 104558 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Errors & Debugging
Date: Thursday, August 17, 2006 3:53:49 PM         
   


> > > Hi! can anyone help me, i'm creating a program, acutally a matrix that can check combinations from a no. of items so i can get which items has discounts. i try to use array but as the no. of items increases, the no. of combinations also increases as i think that i reached the maximum no of elements in the array. i also tried to use macro substitution but i'm not that successful..
> > >
> > > Thanks,

> >
> > Can't you use a table instead of the array? In VFP9, the array size limits have been removed.
> > --
> > Eric den Doop
> > www.foxite.com - The Home Of The Visual FoxPro Experts

>
>
> Hi Eric for the help, I also tried to use table but i think it can't handle it also..
> i also done something to go beyond the limits of the array but as the combination increases it took the process to long..
> any suggestions..
> thanks..


Bert,

How do you create your array? Assuming that you create it using a SELECT command, you could easily use the same command to select to a cursor or to a table. If it takes a long time, it is probably because you need to optimize your query. This is simply a matter of adding the correct indexes. Note that Rushmore will only use an index that does not have a filter. Check your WHERE and JOIN ... ON clauses. You will need an index for each field contained in a WHERE clause and an index for each field in the ON clause.

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

How to make a Matrix Posted by Bert Murillo @ 8/17/2006 3:47:31 AM
RE: How to make a Matrix Posted by Eric den Doop @ 8/17/2006 8:50:08 AM
RE: How to make a Matrix Posted by Bert Murillo @ 8/17/2006 11:11:45 AM
RE: How to make a Matrix Posted by Ken Murphy @ 8/17/2006 3:53:49 PM
RE: How to make a Matrix Posted by Koen Piller @ 8/17/2006 1:01:04 PM
RE: How to make a Matrix Posted by Joselito Watiwat @ 8/17/2006 2:53:06 PM