DK11 for Delphi | GisSqlQuery.TGIS_SqlQuery | Classes | Constructors | Methods | Properties
Calculates a logical value of WHERE-like statements for non SQL-based tables.
// Delphi type TGIS_SqlQuery = class( TGIS_Object ) end;
// C++ Builder class PASCALIMPLEMENTATION TGIS_SqlQuery : public TGIS_Object { };
→ TObject → TGIS_Object
Name | Visibility | Description | |
---|---|---|---|
BindSqlQueryCallBack | public | A callback to be executed form TGIS_LayerVector upon binding layer to the SQL query object (connecting field access methods) | |
Parse(TGIS_SqlQueryFieldFun; TGIS_SqlQueryBindFun; TGIS_SqlQueryFieldBindFun; TObject; Integer) | public | Parse each record. | |
Parse(TObject; Integer) | public | Parse each record. | |
ParseAsBoolean(TGIS_SqlQueryFieldFun; TGIS_SqlQueryBindFun; TGIS_SqlQueryFieldBindFun; TObject; Boolean; Integer) | public | Parse each record and cast result as boolean. | |
ParseAsBoolean(TObject; Boolean; Integer) | public | Parse each record and cast result as boolean. | |
ParseAsFloat(TGIS_SqlQueryFieldFun; TGIS_SqlQueryBindFun; TGIS_SqlQueryFieldBindFun; TObject; Double; Integer) | public | Parse each record and cast result as float. | |
ParseAsFloat(TObject; Double; Integer) | public | Parse each record and cast result as float. | |
Prepare | public | Calling once per scope. | |
RePrepare | public | RePrepare precompiled a query. | |
Supported operators are:
Supported math functions are:
Supported string functions are:
To guarantee query compatibility across different SQL servers Date should be encoded using predefined functions: