invalid object when use of temporary table

oursgris · August 2010

hello
i want to use a stored procedure
I use the creation assistant (after the parameters) i have an error "Object Name #NAMEOFTEMPTABLE not valid"
Is there any way to remove this error ?

Note :
The stored procedure consist of :
CREATE TABLE #NAME (...)
INSERT INTO #NAME (...)
SELECT #NAME

In the SQL Server management studio, it works and send me only one table

Regards

oursgris · August 2010

The solution is :

wrote:

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

anandsrivastav1087 · April 2024

I have same problem. given link is not working for workaround. please suggest me?

stg · 10:32AM

Hello!

In the FastReport Query/Procedure Wizard, call a stored procedure with explicit result set metadata:

EXEC dbo.YourStoredProcedure @Param1 = @p1
WITH RESULT SETS (
(
ID INT,
ItemName NVARCHAR(100),
Amount DECIMAL(18, 2)
)
);

Execute the stored procedure in C# code into a DataTable and register it in the report:

using var conn = new SqlConnection(connString);
using var cmd = new SqlCommand(‘dbo.YourStoredProcedure’, conn) { CommandType = CommandType.StoredProcedure };
using var adapter = new SqlDataAdapter(cmd);
var dt = new DataTable(‘SpTempTableData’);
adapter.Fill(dt);

using var report = new Report();
report.Load(“Report.frx”);
report.RegisterData(dt, “SpTempTableData”);
report.GetDataSource(“SpTempTableData”).Enabled = true;
report.Prepare();

invalid object when use of temporary table

Comments