<< Click to Display Table of Contents >> Navigation:  »No topics above this level« Export

Query result has the following methods:

 

function SQLData: THtSQLData;
function AsString: string;
function AsDouble: double;
function AsInteger: integer;
function AsValue: TValue;
function AsRow: TVarDynArray;
function AsRowSet: TVar2DynArray;
function AsDataset: TDataset;
function AsStringList: TStringList;
function AsDatapacket: THtXMLNode;
function AsHTML(const ATemplate: hstring): hstring;
procedure ToStringList(AValue: TStrings; const ADelimiter: string = ';');
procedure ToObjectList(AValue: TList);
procedure ToDataset(AValue: TDataset);
procedure ToCSVFile(const AFileName: string; AddHeader: boolean = true; ADelimiter: char = ',');
procedure ToJSONFile(const AFileName: string);
procedure ToXMLFile(const AFileName: string; const ARoot: string = 'Root'; const ATag: string = 'R');
procedure ToSQLFile(const AFileName, ATable: string);
procedure ToSQLTable(ASchema: TDMSchema; const ATable: string);
procedure Unserialize(AConstructor: THtUnserializeCreate);

 

Also it supports IDMDatasource interface, so can be registered as datasource for another query.

 

Single value result:

 

function AsString: string;
function AsInteger: integer;
function AsDouble: double;
function AsValue: TValue;

 

Single row result:

 

function AsRow: TVarDynArray;