Solved

Accesing temporary tables in SQL Server using Ado components

Posted on 2004-10-11
5
369 Views
Last Modified: 2013-11-23
Hi,

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"


Regards,
0
Comment
Question by:fischermx
5 Comments
 
LVL 6

Expert Comment

by:vadim_ti
ID: 12281397
only suggestions:

1)may be your KeepConnection is false, and connection is closed?
2)try to check the same with global temporary table ##temp1
so you will know if a problem is with a connection
0
 
LVL 5

Expert Comment

by:Voodooman
ID: 12281755

Hi

When you create the temp tables - make sure the queries  are server side.

I am not sure how you do that with Delphi (I dont use ADo with Delphi - only VB)

Then do a simple test on the connection by executing a query like

conn.execute('Select into #temp from Customers');

and then

But it goes something like MyDs=conn.open('Select * from #Temp');

That should work (excuse my Delphi here but like I said I dont use ADO with Delphi)

Voodooman

0
 
LVL 1

Author Comment

by:fischermx
ID: 12328314
The solution was to create the temporary tables in one command, then in a second command fill them and then perform as many individual commands as temporaty tables to retrieve each results sets.
Sorry, for post this too late.
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 12526993
Question answered by asker or dialog valuable.
Closed, 500 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now