Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple detail bands
Message
From
08/08/2007 06:10:49
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Multiple detail bands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01246721
Message ID:
01246721
Views:
78
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
Map
View

Click here to load this message in the networking platform