Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Multiple detail bands
Versions des environnements
Network:
Windows 2003 Server
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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement