Help!TStoredProc & MS SQL Server 6.5

cxf

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Help!TStoredProc & MS SQL Server 6.5

Hi,

I have a stored procedure with complex logic.
I have to use a lot of SELECT-statments and temp tables
to make out the final resoult set.TStoredProc returns
the resoult set of the first SELECT-statment but not
the final resoult set that I really need(the resoult set of the last
SELECT-statment).

What am I missing?

Thanx.

Y H Chang

Brad Mille

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Help!TStoredProc & MS SQL Server 6.5

Well I do believe that you can only return one result set out of a
stored proc. I don't knnow how to write a stored proc to return anything
put parameters, so I can't help you on the syntax of your proc...

RAMESH THEIVENDRA

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Help!TStoredProc & MS SQL Server 6.5

DELPHI supports only one result set from stored proc. You can try to
workaround this problem by using UNION e.t.c

T.Ramesh.

Quote

cxf wrote:
> Hi,

> I have a stored procedure with complex logic.
> I have to use a lot of SELECT-statments and temp tables
> to make out the final resoult set.TStoredProc returns
> the resoult set of the first SELECT-statment but not
> the final resoult set that I really need(the resoult set of the last
> SELECT-statment).

> What am I missing?

> Thanx.

> Y H Chang

Other Threads

1. TStoredProc and MS SQL Server 6.5

2. MS-SQL 6.5 & MS-SQL 2000

3. D4/sql 6.5 to D5/sql 6.5 creates Tstoredproc error

4. Delphi 4 & MS SQL Server 6.5

5. ms sql server 6.5 & datetime

6. ms sql server 6.5 & datetime part II

7. BDE Vendor Init & MS SQL Server 6.5

8. Help: Upgrading from MS SQL 6.5 to MS SQL 2000

9. Help!MS SQL Server 6.5 and data-entry form

10. MS-SQL server 6.5 vs Interbase server ???