grw
Fri Jan 16 06:56:16 CST 2004
Use a view if possible.
<anonymous@discussions.microsoft.com> wrote in message
news:0a4101c3db79$4b9704e0$a601280a@phx.gbl...
> 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.
>
> >-----Original Message-----
> >The database wizard can use either tables or Access
> queries (Views) as
> >record sources - what is a temp table?
> >
> >--
> >~ Kathleen Anderson
> >Microsoft MVP - FrontPage
> >Spider Web Woman Designs
> >
http://www.spiderwebwoman.com/resources/
> >
> >
> >Kevin <anonymous@discussions.microsoft.com> wrote:
> >> 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
> >
> >
> >.
> >