The problem is with the part: !DELETED("invdet")

See the help file: the table is re-opened for the SELECT.

Use:

SET DELETED ON
SELECT ...;
  into cursor
* without the !deleted() clause

Regards, Hilmar.

>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