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;

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.

See Also

• TCustomDASQL.Execute