Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiple detail bands
Message
De
08/08/2007 06:10:49
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Multiple detail bands
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01246721
Message ID:
01246721
Vues:
79
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
Fil
Voir

Click here to load this message in the networking platform