>Hello All,
>
> I am coming across a repeated problem with Foxpro and i m trying to find an answer. I am using VFP 5.0(dont ask) I have a database with 23 tables in it one of which has 750,000 records in it and 30 feilds. I am tring to do simple things with the table such as set filter with multiple args and even such simple things as count and it is locking up my syetem. I am running a PIII 650 with 128 mbs RAM and NT 4.0 SP6 my VFP is 5.0 SP3 is this just too much to ask from fox??? TIA
The size limit is 2 gb. On such a table as you mention, rather than trying to use a filter, you'll probably get much better results with either an SQL SELECT statement, or if the data is to be updated, an updateable local view.
George
Ubi caritas et amor, deus ibi est