TMSSQL.ExecuteForXML Method

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

Class

TMSSQL

Syntax

procedure ExecuteForXML(Stream: TStream; OutputEncoding: TMSOutputEncoding); overload;

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 TMSSQLOutputEncoding type is declared in the MSAccess unit.

See Also

• TCustomDASQL.Execute