>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 >>
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