Stored Proc use in Database Results Wizard

[Kevin]

Hello. I am trying to use the database results wizard
with a stored procedure that happens to use some temp
tables in its execution. FP Database Results Wizard is
choking on this, stating the temp table is an invalid
object. This seems awfully constricting, so I am thinking
that I am missing something. Might someone be able to
assist? Thanks. Kevin

 

[Kathleen Anderson [MVP - FP]]

The database wizard can use either tables or Access queries (Views) as
record sources - what is a temp table?

 

[Guest]

Thanks for the response. A temp table is a temporary
table that is created by SQL and used only for a specific
query or stored proc and then is deleted. Here's what I
am trying to do. In the database wizard, I put in my SQL,
which is in the form of a stored proc (looks like
this...exec my_stored_proc 'parameter1', 'parameter2').
When I click Verify in the wizard, FP tells me that one of
the temp tables that is created and used in the stored
procedure is an invalid object. I assume this is because
the wizard is parsing through the stored procedure to make
sure the tables that are used actually exist in the DB.
So, my question is, is there a way around this? If not,
is there another way to solve this problem. Thanks you.

 

[grw]

Use a view if possible.

Thanks for the response. A temp table is a temporary
table that is created by SQL and used only for a specific
query or stored proc and then is deleted. Here's what I
am trying to do. In the database wizard, I put in my SQL,
which is in the form of a stored proc (looks like
this...exec my_stored_proc 'parameter1', 'parameter2').
When I click Verify in the wizard, FP tells me that one of
the temp tables that is created and used in the stored
procedure is an invalid object. I assume this is because
the wizard is parsing through the stored procedure to make
sure the tables that are used actually exist in the DB.
So, my question is, is there a way around this? If not,
is there another way to solve this problem. Thanks you.