Topics with keyword "Query"
1. List of global events
... by DLL
BeforeSynchronization (ABORT=YES)
AfterSynchronization
BeforeRunDatabaseQueryTool (ABORT=YES)
Variable: IncludeAllInactiveLayers...
2. HideDataCollectorOptionsItem
... value:
none
Example:
Begin HideDataCollectorOptionsItem('RunDatabaseQuery'); End.
Output in...
3. ParameterizeRegressionModel
...:variant;
tb :TFieldMapTableScriptWrapper;
begin
tb := Trees.GetQueryResult('DBH_mm, Height_m','');
...
4. Example
... disabled layers in Database Query Tool Selection window.
In global...
5. Database
...Database Database
In this chapter:
Value
ValueAsString
ValueAsinteger
ValueAsFloat
ValueAsboolean
OldValue
PreviousValue
BOF
EOF
RecordCount
State
SetValues
SetValuesFromXML
CrownProjection
CrownProfile
CrownProfilePoints
StemProfile
OldLayer
SavePosition
RestorePosition
SaveState
RestoreState
SavePositionAndState
RestorePositionAndState
Open
Close
First
Last
Next
Prior
Edit
Post
Append
Delete
Cancel
Refresh
Locate
ClearTable
Filter
Filtered
CheckFilter
SetFilterExt
ClearFilterForChildLayers
DeepFilter
EnableCachedUpdates
ApplyUpdates
GetAttributeValue
GetQueryResult
DeleteFrom
Update
CreateMemTable
SaveToDBF
SaveToExcel
GetMinOfAttributeValues
GetMaxOfAttributeValues
GetMeanOfAttributeValues
GetSumOfAttributeValues
GetRecordCount
GetLookupTable
GetLookupListValue
GetLookupListAttributeValue
GetID
GetIdAttributeName
GetIdSQL
SaveTimeStamp
File2Blob
Blob2Folder
String2Blob
Blob2String
FillAttributeValues
MarkValuesAsConditional
RoundAttributeValues
GetListOfChildLayers
GetPercentageOfFilledAttributes4Record
GetPercentageOfFilledAttributes4Table
6. GetQueryResult
GetQueryResult GetQueryResult function
Prototype:
function GetQueryResult(...
7. Navigator & DQT
... & DQT
In this chapter:
AddItemToNavigatorXML
DBNavigatorVisible
DBNavigatorConfirmDelete
QueryBuilderEnabled
EnableQueryBuilder
DisableQueryBuilder
8. QueryBuilderEnabled
QueryBuilderEnabled QueryBuilderEnabled property
Prototype:
property QueryBuilderEnabled:...
9. EnableQueryBuilder
EnableQueryBuilder EnableQueryBuilder procedure
Prototype:
procedure EnableQueryBuilder;
Description:...
10. DisableQueryBuilder
DisableQueryBuilder DisableQueryBuilder procedure
Prototype:
procedure DisableQueryBuilder;
Description:...
11. Database
...Database Database
In this chapter:
Refresh
EnableCachedUpdates
ApplyUpdates
StartTransaction
Commit
CommitRetaining
Rollback
RollbackRetaining
ClearAllFilters
GetQueryResult
PerformQuery
OpenTable
SaveRecordToDeletedLog
SaveRecordsToDeletedLog
BackupDatabase
PostAllData
ReloadLookupLists
PostProjectAndLookupTablesToSynchroJournal
PostLookupTablesToSynchroJournal
PostSelectedLookupTablesToSynchroJournal
PostFileToSynchroJournal
ChangedAfterLastSynchronization
12. GetQueryResult
GetQueryResult GetQueryResult function
Prototype:
function GetQueryResult(...
13. PerformQuery
PerformQuery PerformQuery procedure
Prototype:
procedure PerformQuery(const ...
14. Navigator & DQT & Extensions
... & Extensions
In this chapter:
RunFieldMapExtension
HideExtensionMenu
ShowExtensionMenu
RunDatabaseQueryTool
ShowExcelPreview
AddItemToNavigatorXML
DBNavigatorVisible
DBNavigatorConfirmDelete
GetSpeciesGroupID
15. RunDatabaseQueryTool
RunDatabaseQueryTool RunDatabaseQueryTool procedure
Prototype:
procedure RunDatabaseQueryTool ...
16. Handling exceptions
...:TTableWrapper; begin q := Project.GetQueryResult('SELECT ID FROM Plots'...
17. Working with Field-Map data – using SQL queries
... a basic tool for Querying and manipulating data. This...