temporal tables used by SQL in reports

Pedro Mir

Hello Support,

Some SQL uses temporal tables. By example,

select * into #TEMP from data;
select * from #TEMP;
drop table #TEMP;

When I use temporal tables like this fast-report respond "Invalid object name #TEMP"

In SQL this SQL runs ok.

What can I do so fastreport be able to get results in SQL that use temporal tables?

Thanks,

Pedro

AlexTZ

Hello,

Q: Stored proc with temp table does not work in FR (I get error message "invalid objectname...")
A: Read about similar problem and workaround here:
http://objectmix.com/ado-dao-rdo-rds/25615...res-temp-t.html

Add these lines to the beginning of your sp:

IF 1=0 BEGIN
SET FMTONLY OFF
END