Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange behaviour
Message
From
11/07/2006 02:12:01
 
 
To
07/07/2006 17:20:07
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01134591
Message ID:
01135206
Views:
17
>Here's a strange. The following code works as you would expect:
>
>select tblmaster.*,tbltotals.* ;
> FROM tblmaster ;
>    INNER JOIN tbltotals ;
>   ON  tblmaster.int_id = tbltotals.int_id;
> ORDER BY tbltotals.highcount desc ;
> into cursor crsTempreport
>
>select crsTempreport
>*brow
>
>report form rptbusiestintersections range 1,1 to printer prompt preview noconsole nowait
>_screen.Visible = .f.
>select tblmaster
>
>
>however, if the commented line BROWSE is activated, the code fails with an error that suggests the cursor is no longer in the active workarea when the report is called. The specific message is that the first field of the report cannot be found. The code in question is contained in a menu.
>
>Any ideas as to what's at issue here?

check the datasession
select tblmaster.*,tbltotals.* ;
 FROM tblmaster ;
    INNER JOIN tbltotals ;
   ON  tblmaster.int_id = tbltotals.int_id;
 ORDER BY tbltotals.highcount desc ;
 into cursor crsTempreport

select crsTempreport

XXX=SET("DATASESSION")
brow
IF SET("DATASESSION")#m.xxx
  WAIT WINDOWS "datasession is changed"
endif
release xxx

report form rptbusiestintersections range 1,1 to printer prompt preview noconsole nowait
_screen.Visible = .f.
select tblmaster
Previous
Reply
Map
View

Click here to load this message in the networking platform