>I populate a cursor for each detail band. The parent cursor is "aporg" and to create the deduction cursor "adeduc" I use the following query:
>
>INSERT INTO adeduc (pd_phaccno, pd_name, pd_value, pd_ivat, pd_glkey, pd_drcr) ;
> SELECT pd_phaccno, pd_name, pd_value, pd_ivat, pd_glkey, pd_drcr ;
> FROM bkplpayd, aporg ;
> WHERE bkplpayd.pd_phaccno = aporg.ph_accno and pd_delflag != .T. ;
> ORDER BY pd_phaccno
>
>The records in adeduc is correct (4 records), but for some reason additional records were inserted into aporg, but containing only '**********'. The report prints correct (excluding the '****' records), I'm just worried that the cursor can become were large.
>
>What can I do to prevent this?
Are you sure the record are really inserted in aporg .. or are you browsing the table which has some relations and skip to settings that are just letting you see the records and their relations. IOW .. the **** records aren't really in the table, it's just that the browse is showing you a repeat of the parent table in the relation.