Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Accesing temporary tables in SQL Server using Ado components

Posted on 2004-10-11
5
Medium Priority
?
398 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
4 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses

877 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