Accesing temporary tables in SQL Server using Ado components
Posted on 2004-10-11
I'm using Delphi 7 and Ado components to connect to a SQL Server 2000 server.
I have a T-SQL routine that creates serveral #Temporary tables.
So, I want to first, call this routine from my form, then call individidual TAdoQuerys to retrieve each individual of the resultsets.
Since all the components share the same connection (I have only one TAdoConnection in my app), this seems to be supposed to work, since temporary tables, belong to the current user's connection.
However, it doesn't work so. After I call the routine that creates the temporary tables (using either a TAdoCommand or a TAdoQuery), I have the temporary tables created, but my calls to retrieve the tables (Select * From #Temp1), return me the error "Invalid object name #Temp1"