Problems with multiple recordsets when calling sp_help

From: "peter everix" <peter.everix@xxxxxxxxxx>
Date: 20 Jul 2005 13:15:53 GMT

Hi,

I'm using sp_help <table_name> to get all the information for the given
table name.

With ADOStoredProc.nextrecordset i can go to the next resultsets , but
after 5 recordsets i get the error 'ADODataset: Recordset is not open'.
I'm getting this error after the 'Data_located_on_filegroup'
information.

When i execute the sp_help in query analyzer i see there is more data,
but i can't access it in delphi.

I'm using D7 with ADO2.7 , connection to a sql2000 server.

Any idea what's going wrong

Regards,
Peter
.

Prev by Date: Re: SetConsoleCtrlHandler called when accessing ODBC/OLEDB datasource
Next by Date: Re: Preventing Duplicates in BeforePost event.
Previous by thread: IDE no response
Next by thread: General question from someone new to ado
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL
... > CancelUpdate ... A collection of ADO keywords. ... Prev by Date: ...
(microsoft.public.vb.general.discussion)
Re: SQL
... > UpdateBatch adAffectAllChapters ... > CancelUpdate ... Prev by Date: ...
(microsoft.public.vb.general.discussion)
Re: Filter on Recordset not working
... it worked great mate. ... Recordsets and variables appear because this code has been built slowly ... Peter ... Prev by Date: ...
(microsoft.public.access.formscoding)
Export ADO recordsets From multiple tables to text file
... I am trying to export the recordsets from multiple tables into the same ... Prev by Date: ...
(microsoft.public.vb.database.ado)
SQL
... UpdateBatch adAffectAllChapters ... CancelUpdate ... Recordsets ... Prev by Date: ...
(microsoft.public.vb.general.discussion)