[This topic is migrated from our old forums. The original author name has been removed]
There seems to be a bug in the search and replace feature when editing scripts in SQL Commander. When I issue the replace command I am told the text has been replaced, but the contents of the editor buffer do not change. It is not clear what specific conditions trigger this behavior, but it seems to happen with great frequency when editing scripts. Here are the steps that reproduce this issue on my Windows 7 64-bit system with the official 9.0 release:
1) Press Ctrl-T to create a new SQL Commander tab
2) Paste in the following script
select
"Nav$Sales Line"."Document No_"
from
"Nav$Sales Line"
3) Press Ctrl-H to invoke the Replace dialog
4) Enter "Nav$Sales Line" (including the quotes) in the "Find What" field
5) Enter replacement text in the "Replace with" field
6) Press the Find button
Expected Result:
Text is found and replaced
Actual Result:
- DbVis displays the message: "2" occurrences have been replaced
- The cursor is advanced to just after the last match
- The matched text is not replaced
Regards,
David
Hi David,
Thanks for reporting this. It is the same bug as reported here:
http://www.dbvis.com/forum/thread.jspa?messageID=15293
The work-around is:
+ Open the Replace dialog,
+ Check the "Use" checkbox in the Options area, select Wildcards, and uncheck "Use" again
+ Click Find
Best Regards,
Hans
a
anonymous
said
over 10 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Search and replace problem
Hans,
Thanks, the workaround does the trick. It was a mildly annoying bug, but not a big deal since I often end up using Notepad++ anyway to perform more advanced editing.
Best Regards,
David
Hans Bergsten
said
over 10 years ago
[This reply is migrated from our old forums.]
Re: Search and replace problem
Hi David,
Hopefully we will get this fixed soon.
We have editor improvements on our todo list. Can you tell us what Nodepad++ features you like to see in the DbVisualizer editor?
Best Regards,
Hans
Roger Bjärevall
said
over 10 years ago
[This reply is migrated from our old forums.]
Re: Search and replace problem
David,
Just to inform you that this is now fixed in the 9.0.1 version.
Regards
Roger
anonymous