General information
Category:
Reports & Report designer
Title:
Multiple detail bands
Environment versions
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only