Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Relational Databases
Expertise: Beginner
Jul 14, 1999

Select Stored Procedures in MS SQL 7

Question:
How do I access an MS SQL 7 Stored Procedure that returns a multi-row Dataset through Delphi 3?

InterBase allows selecting from a Stored Procedure. MS SQL 7 only allows selects from tables, views, or from a "Rowset Function," but not from a Stored Procedure.

Answer:
Hm...even Oracle allows you to do this. Well, with a little bit of trickery. What you do is create a dummy table with a single field in a globally accessible database. (I usually use WORKING.)

Once you do that, the select syntax should go like this:

 
SELECT 
FROM WORKING..DummyTable
Without seeing your code, I can only suppose that you're probably doing the following:
 
SELECT Field1, Field2, FieldX
FROM 
That's not allowed in any server database that I know of.
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap