>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


Make sure the THISFORMSET.vlinvoiceid had a valid value when you are getting up to the larger table ranges.

You might want to delete your indexes and recreate them for the two tables in question... they may be corrupt. Reindex them.

See how this works.

Tommy