Field-Map Scripting

4.4.4.10 GetQueryResult

GetQueryResult function


Prototype:

function GetQueryResult(const SQL: string) :TTableWrapper;

Description:

The GetQueryResult function returns a wrapper for a table which is a result of the specified full query. The query takes place in the project's data space and represents no limitations for the active plot. Note: This function also works for the layer wrapper.

Syntax:

variable := Project.GetQueryResult(SQL);


Part

Description


variable

A variable declared as an instance of the TTableWrapper class


Project

A reference to the Field-Map project as defined in Field-Map Project Manager


SQL

Full SQL query as string

Return value:

a wrapper for a Field-Map table with the specified query applied to it



See also:

Refresh; EnableChachedUpdates; ApplyUpdates; StartTransaction; Commit; CommitRetaining; Rollback; RollbackRetaining; ClearAllFilters; GetQueryResult; PerformQuery; OpenTable; SaveRecordToDeletedLog; SaveRecordsToDeletedLog; BackupDatabase; PostAllData; ReloadLookupLists; PostProjectAndLookupTablesToSynchroJournal; PostLookupTablesToSynchroJournal; PostSelectedLookupTablesToSynchroJournal; PostFileToSynchroJournal; ChangedAfterLastSynchronization