Well I havent tried the code yet...
The .rpt file contains these sort of lines
.declare myID 99
.declare myNote 9999999
.declare rateCount 9999
.define get_in
select key, key1, rate_pr,Nt
into booking_seq, f_no,
print_rates, myNote
from ed_tab
where ed_tab.tag = 'BKNG'
and ed_tab.key = 'PRN'
and ed_tab.user_id = usr
I just want to know ..how to do this..I mean how to read this type of file which contains declared variables and sql query...If I open the file and read line by line how could I know on which line variable is declared and on which line query is written..because after reading line by line ,I will have generate the report.....
Need your guidance only....
|