Devart Forums

Hi!
I am using Delphi 7 and I have a MSQuery component which creates a temporary table. This component's query is parameterized. If I try to access the temporary table after creating it the table can not be found. If I don't use parameters and manually create the sql query and put it in the component using sql.add I can access the temporary table with a problem. Is there an option I have to set? What am i doing wrong?

Josh

Please specify the version of server you are using.

ms sql server 2008 enterprise edition

Hi, could it be you are closing the connection after creating the temp-table and reopening it before accessing the table again? I had a similar problem when creating a temp-table from one connection and accessing it from another: when closing the connection (SPID) which created the table, the temporary table was destroyed still if there was other cocnections accessing it. Hope this helps.
best regards
Toni

i'm definitely not closing the connection. i made a example application where i basically try what i explained above.
the working example:
i connect. i create the the temp table. i query the temp table.

the example that doesn't work:
i connect. i create the the temp table. i set the query's paramters. i query the temp table. i reveive an error message saying the table does not exist


josh

We could not reproduce the problem. Please send us a small sample to reproduce it.