>Hi Cetin!
>Can you, please, specify what do you exactly mean by select data into a table?
Valentin,
At the time of report form calling you could SQL select the data of the report to a new temporary table. Better explain with code :
select * from mytable1 ;
inner join mytable2 ;
on mytable1.id = mytable2.id ;
where mytable1.orderid = ?somevalue ;
into table tcMyReport
* Report form would use tcMyReport
* A reports table will hold data
report form myReport preview
use in "tcMyReport"
insert into reports (dtprinted, description, dbfcontent,fptcontent) ;
values (datetime(),"Some description")
select reports
append memo dbfcontent from ("tcMyreport.dbf")
append memo fptcontent from ("tcMyreport.fpt") && SQL could produce no fpt
erase tcMyreport.*Cetin