Delphi 2005, ADO, XML



Hi,

Could someone plz post a working example of retrieving XML data
returned by a stored procedure using ADO and delphi 2005? I am using
Delphi 2005, Microsoft SQL Server 2000.

Lets say, I have a stored procedure called myStoredProc which returns
data in an XML. The stored proc works fine in Query Analyzer. I can
also run stored procedures that don't return anything from Delphi 2005.
But when it comes to stored procs returning XML, I am really lost.
Comprehensive help on ADO w/ Delphi is almost non-existent! Examples on
the web refer to older versions of Delphi and have not been very
helpful. :-(

Any help is greatly appreciated. Thx!

Zee.

.



Relevant Pages

  • Re: Stored Procedure for Paging
    ... The Stored procedure ... > I wanted to Display the Data in a GRID (Delphi using ADO). ...
    (microsoft.public.sqlserver.server)
  • Re: Stored Procedure for Paging
    ... The Stored procedure ... > I wanted to Display the Data in a GRID (Delphi using ADO). ...
    (microsoft.public.sqlserver.programming)
  • Re: storedproc.edit: "select permission denied" when assigning to a field
    ... Delphi isn't doing anything inside the stored procedure, ... your loop that you do "updatebatch" to actually apply the changes to the ... That would probably go much faster since the database engine will update the ...
    (borland.public.delphi.database.ado)
  • Hidden error kills my transaction. Help!
    ... I have a stored procedure with parameter ... @ID_DOC CharOUTPUT, --for uniqueidentifier ... the procedure is called from Delphi using ADO ... The transaction is rollbacked ...
    (microsoft.public.sqlserver.programming)
  • Re: Hidden error kills my transaction. Help!
    ... Try SET NOCOUNT ON at the beginning of your stored procedure. ... SQL Server MVP ... > - the procedure is called from Delphi using ADO ...
    (microsoft.public.sqlserver.programming)