Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's with the cursor?
Message
 
To
13/12/2005 12:22:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01077546
Message ID:
01077548
Views:
43
What about:
*-- First cursor[NOT Working with the report listener?]
CREATE CURSOR cCust (cID c(5), cName C(50))
INSERT INTO cCust VALUES (1,'asdasdasd')
SELECT cCust
*-- Common code
lolistener = .null.
do(_reportoutput) with 5, lolistener
lolistener.targetfilename = "bob.html"
lolistener.quietmode = .T.
REPORT FORM 'rBob' OBJECT lolistener
Also check if some grid has the focus before report. If it is so move the focus to some other control before REPORTing.


>The code below is giving me different result. Basically, when I use the second code it works fine with the Common code(Report listener), but when I switch to the First code it prompt me to open a table(Open table dialog box). Am i missing something with the report listener? TIA!
>
>
>*-- First cursor[NOT Working with the report listener?]
>CREATE CURSOR cCust (cID c(5), cName C(50))
>INSERT INTO cCust VALUES (1,'asdasdasd')
>
>
>
>*-- Second cursor[Working with the report listener?]
>SELECT cid, cname FROM customer WHERE cid = "12345" INTO CURSOR cCust
>
>
>
>*-- Common code
>lolistener = .null.
>do(_reportoutput) with 5, lolistener
>lolistener.targetfilename = "bob.html"
>lolistener.quietmode = .T.
>REPORT FORM 'rBob' OBJECT lolistener
>
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform