Search and Replace

Sirkel Toolbar Search and Replace Data
What does Search and Replace do? After filling in and selecting a number of data, it searches for the input value in the entire database. You can replace it with another value. An example is here the value ' Sport ' in the screen below and searched in all the tables of AdventureWorks. The list below shows the tables, the value and the results in a grid.
Search and Replace: overview and list of the options
PossibilityActionResults
SirkelData - Search Replace Data - Check AllAll possibilities - tick tables in the list.SirkelData - Search Replace Data - Tables
SirkelData Data Search Replace Clear Selection ButtonNo options - check tables in the list.SirkelData Search and Replace Data Remove All in List
SirkelData - Search Replace Data - Find TableFind the table in the list. 
SirkelData - Search Replace Data - ValueEnter the value that will be searched for in the selected table(s). 
SirkelData - Search Replace Data - TypeSpecify the type (numeric or text) to be searched for. 
SirkelData - Search Replace Data - LikeIf text is selected, indicate what kind of LIKE will be used in the SQL.
Selections you can make:
1) Find the exact value.
2) Finds any values that start with input.
3) Finds any values that end with input.
4) Finds any values that have input in any position.
 
SirkelData Search and Replace Data Search Value ButtonLook up the value entered in the selected table(s). 
SirkelData - Search Replace Data - ClearClear the value and selected options. 
SirkelData - Search Replace Data - Row Start EndNumber of rows that have the input value.
Afterwards you can adjust the rows for a possible update.
 
SirkelData - Search Replace Data - New ValueThe new value you can define. 
Fill in the new value in the grid. 
SirkelData Search and Replace Data Update Data ButtonRun the updates. 
Sirkel Button CloseClosing the window. 
SirkelData - Search Replace Data - Results GridResults of the updates.
Here you have the option to individually update or delete a selected value.
 
SirkelData Data Search Replace Update Logs TabIf you click on the 'Update Logs' tab, the results after one or more update(s) are displayed in a table.
SirkelData - Search Replace Data - Print PreviewGenerate a print preview of the results in the grid. 
SirkelData - Search Replace Data - Export ToSelect the type in which the results are saved. 
SirkelData - Search Replace Data - Save ResultsSave the results in the chosen type.