Hi,

I have big problem .... Please, help me !!!!!!!

I have two tables INVOCES /500 records/ and INVDET /26000 recs/ . To print invoces i use command :

SELECT invoices.*,invdet.*,invdet.td as to;
FROM invdet,invoices;
WHERE invdet.invoiceid=invoices.invoiceid;
AND invoices.invoiceid=THISFORMSET.vlinvoiceid;
AND !DELETED("invdet");
ORDER BY art;
INTO CURSOR inv_prn .

It work fine.

When records in INVOICES passes 5000 and INVDET - 50000 this command generate empty cursor . To edit invoice i use "local view". When I update this view SELECT command work fine.

Why ?

VFP6.0 SP5 , Win98SE.

Krasimir Georgiev
Sofia
Bulgaria