Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Endless print - of one page
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00885517
Message ID:
00885583
Views:
11
Hi Sergey,

We are printing an invoice with a logo on it. We use List&Label 8 for printing. It keeps printing the same page over and over again.
The wrong selected cursor was my first idea too, but we dont use any memvars,variables or "table." for printing. I suppose otherwise we would get errors in List&Label.
It is only a cursor with the filled in content created via SQL View.

SQL Statement(Shortened fieldlist with table.*) :
SELECT akkop.*,appos.*,apmas.*,aksum.*,
FROM akkop LEFT OUTER JOIN appos ON Akkop.aufnr = Appos.aufnr LEFT OUTER JOIN aksum ON Akkop.aufnr = aksum.aufnr and 0 = aksum.waehrung LEFT OUTER JOIN apmas ON appos.aufnr = apmas.aufnr and appos.posnr = apmas.posnr WHERE Akkop.aufnr >= ?lnvaufnr and Akkop.aufnr <= ?lnbaufnr order by akkop.renr, akkop.aufnr, appos.posnr, apmas.uposnr into cursor cur_print

lnvaufnr = Invoice Number
lnbaufnr = Invoice Number

All forms this project is running on have private datasessions.

Thanks in advance
Marvin Blase (tA-logistic Software GmbH)
You'll never notice the good things if you haven't seen the bad.
Previous
Reply
Map
View

Click here to load this message in the networking platform