Hi Krasimir,

Do you have some ERROR routine active that might be suppressing an error that might be coming up?

Some minor things (don't think they cause your problem):

1) "...as TO;" - "TO" is a reserved word and should be changed to something else;
2) I think it would be cleaner to have the first WHERE expression also use THISFORMSET.vlinvoiceid instead of invoices.invoiceid;

Good luck,

JimN

>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