Skip to content

4.6 Update Fields

Jump to bottom Edit New page
Steven Sotelo edited this page May 21, 2015 · 6 revisions

This option facilitates update rows values of the tables into database and running SQL querys in the database.

Update files

File: This allow you select the source file that contains all querys desired to run in the database Log: The folder where the application will save the files that contain the results QUERY_ERROR: contains the query that the application try to upload but the database refused Type: The application will validate that the query matches with the table Run: This button executes all queries

  • Type: The application will validate that the query matches with the table
  • Log: The folder where the application will save the files that contain the results
    • QUERY_ERROR: contains the query that the application try to upload but the database refused
  • Grid: Every row of the grid indicates one update to do into database. For each row you should fill the column field and value, the column condition is optional, if you don't fill it, the update query will affect all table. when the values is a "String", you should put it inside within apostrophe " ' ". For example: 'Mi value'
  • Run: This button executes all updates

Dev by Steven Sotelo

Logo

Clone this wiki locally