Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wrong cursor selected
Message
From
21/07/2003 14:13:33
 
 
To
21/07/2003 13:47:22
Dennis Schuette
Customized Business Services, Llc
Yuma, Arizona, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00812082
Message ID:
00812094
Views:
10
>I am using VFP 5.0a. The report uses the wrong cursor the first time the report is printed, but each time thereafter it uses the correct cursor.
>
>To debug, I placed a messagebox in the following DE code events to try to find out when the cursor gets switched (they execute in the following order):
>OpenTables() && reports correct cursor
>BeforeOpenTables() && reports correct cursor
>Init() && reports correct cursor
>
>Sequence of events:
>1] In a PageFrame I have a grid and a commandbutton (cmdPrint).
>2] I select a row in the grid.
>3] I click the cmdPrint that creates the cursor 'curReport' used in the report.
>4] The report is called.
>5] The first time, the report uses a cursor 'tempSort' that was previously opened. (If I close 'tempSort', the report works fine the first time, but other parts of the pageframe depend on it being open.
>6] The second time, the report uses 'curReport' correctly.
>
>I saw some discussion in UT about using a grid. The suggestion was to SetFocus() to something other than the grid. So in the cmdPrint.Click() I have a line: 'This.SetFocus()' [I know this is redundant, but I'm willing to try anything!].
>
>I also searched Visual SourceSafe for any occurance of 'tempSort' in the report, and found no reference. I even opened up the .FRX and looked in every field - 'tempSort' is not referenced.
>
>I have spent several hours on this and haven't a clue what to try next.

Is this report called from a form that has a Grid on it? If it is, make sure the some other control other than the Grid has focus before you call your report code.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform