devxlogo

Select Stored Procedures in MS SQL 7

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, FieldXFROM 

That’s not allowed in any server database that I know of.

devx-admin

Share the Post: