|Database Tour Documentation|
Searching and Replacing Text
You can search the text in tables, in report builder (in template), in SQL expressions, in table, field and index lists.
Searching in the report builder
You can search the text among all text objects of the report template. Use the corresponding button or menu item for this.
Searching in the object list
When the object list focused, it is enough to enter first symbols of the table name and press ENTER. Also can be used the corresponding item from the Search menu.
Searching in the field or index lists
You can find a field or index in the list by its name. Follow to the corresponding page and use the corresponding button or the items from the Search menu.
Searching and replacing the text in SQL-expression
You can search / replace the text in SQL expressions (in SQL window, Edit page).
Searching and replacing the text in the table data
There are two search types.
1. Search for the first match in the current column. The search some faster, but it is executed only to the first text that matches the condition.
To search you must enter text to find into the corresponding field right above the table and press ENTER or double click the field. Some quick search options are available through the context menu of the field, where you enter text to find.
Please note that this kind of search has some limitations: for numeric fields, it can search only whole field content, not substrings; for text fields, it can search either whole field content or beginning part of the field only (if the corresponding quick search option turned on).
2. Advanced search. Search some slower, but it has many options and makes possible replacing. This search is available from Search menu.
Before search you must enter text to find (as well as text to replace with, if replace function was called) and select options:
After multiple replacing (if you choose Replace All) you will get the total number of replaced text fragments.
Choose Search Again to search the text, which was searched last time, from the cursor position.
In Database Tour Pro, the replacing can be performed also via field utilities in command line.
1. Only those fields, which are compatible with string format, can be used in search. For autoincrement fields only searching can be used, but not replacing.
3. Sometimes it may be that not all the text is replaced, when you have chosen Replace All. It happens in the following situations (try to avoid such situations):