SQL Update form


SQL update: It is possible to use SQL commands to create and calculate derived variables. For example those complex tasks that exceeds the possibilities of classification, reclassification or aggregation. Only “UPDATE” statement is available.
  1. UPDATE layer Select the layer that should be updated by choosing from a list of available layers.
  2. SET attribute Select the attribute that you want to set a value to.
  3. Refresh list of layers and attributes Click this button to clear selected UPDATE layer and refresh the list of available SET attributes after creating a new one.
  4. Create new attribute Besides updating existing attributes it is also possible to define a new attribute that will be appended to the source data table. Fill in the name of the attribute and parameters of the attribute.
  5. Database structure The selected UPDATE layer is highlighted.
  6. Comments It is possible to add comments that can be saved together with the SQL.
  7. SQL The SQL is created based on the selected UPDATE layer and SET attribute.
  8. Clear SQL Click this button to clear the SQL.
  9. Save SQL It is possible to store the SQL into a *.sql file for further possible use.
  10. Load SQL Click this button to load an already prepared SQL.
  11. SQL Batch Click this button to run SQL Batch or save batch file.
  12. Execute SQL Click this button to execute the SQL.