SDAC

TMSSQL.ExecuteForXML Method

Provides data in readable view for the SELECT statements written using the FOR XML clause.

Class

TMSSQL

Syntax

procedure ExecuteForXML(out XML: string); overload;procedure ExecuteForXML(out XML: string); overload;

Parameters
XML
Is an output parameter where the result of the query execution is written.

Remarks

SQL Server returns data in a specific format when queries with the FOR XML clause are opened using the TDataSet.Open method. In order to obtain data in readable view for the SELECT statements written using the FOR XML clause, you should use one of these overloaded procedures.

The TOLEDBOutputEncoding type is declared in the OLEDBAccess unit.

See Also

© 1997-2019 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback