Search and Replace Data
What does Search and Replace Data do?
After filling in and selecting a number of data, it searches for the input value in the entire database and you can replace it with another value.

SirkelData Search and Replace Data overview and list
Possibility | Action | Results |
---|---|---|
![]() | All possibilities - tick tables in the list. | ![]() |
![]() | No options - check tables in the list. | ![]() |
![]() | Find table in the list. | |
![]() | Enter the value that will be searched for in the selected table(s). | |
![]() | Specify the type (numeric or text) to be searched for. | |
![]() | If text is selected, indicate what kind of LIKE will be used in the SQL. Selections you can make are:
| |
![]() | Look up the value entered in the selected table(s). | |
![]() | Clear the value and selected options. | |
![]() | Number of rows that have the input value. Afterwards you can adjust the rows for a possible update. | |
![]() | The new value you can define. | |
![]() | Fill in the new value in the grid. | |
![]() | Run the updates. | |
![]() | Closing the window. | |
![]() | Results of the updates. Here you have the option to individually update or delete a selected value. | |
![]() | If you click on the 'Update Logs' tab, the results after one or more update(s) are displayed in a table. | ![]() |
![]() | Generate a print preview of the results in the table. | |
![]() | Select the type in which the results are saved. | |
![]() | Save the results in the chosen type. |