>>I have a VIEW and I want to run some SQL and change the record set,
>>and I want to save the original view, because I will need to return
>>to it. How can I do this?
>
>Would SELECT INTO CURSOR work?
Hi Jeff...no, but this does...
local lcAlias
lcAlias = alias()
if m_report = "closerpt"
set database to qc
create sql view qc_view as select * from qc_table where empty(dateclosed)
use qc_view
count
if _tally = 0
if !empty(lcAlias)
select (lcAlias)
endif
return
endif
report form &m_report preview
if !empty(lcAlias)
select (lcAlias)
endif
return
endif
if !empty(lcAlias)
select (lcAlias)
endif
report form &m_report preview
thanks..rob