Page 1 of 1
Request: On SQL Error -> to Editor (or Syntax Check Button)?
Posted: Fri Mar 20, 2020 7:13 pm
by DrJJWMac
When the setup for an SQL search fails because the input syntax is wrong, we get beeps and warnings. The window has already closed. So we have to go back and "Rename" the search (why not "Edit" the search ... the term "Rename" seems confusing???).
This process could be improved when a syntax failure would cause the editor window to reopen directly (with or without the beeps). Alternatively, it would be handy to have a "Check Syntax" button on the editor window before that window is closed and run.
Thanks.
--
JJW
Re: Request: On SQL Error -> to Editor (or Syntax Check Button)?
Posted: Sat Mar 21, 2020 7:09 am
by Jon
I'll take a look.
Rename is used because that apples to static groups. But yes, Edit would be more appropriate for smart groups.
BTW, you might want to test out your searches in the SQL Search dialog before using then in smart groups (Command-Shift-S). It's a bit less work to fix bad syntax there than with smart groups.
Jon
Sonny Software
Re: Request: On SQL Error -> to Editor (or Syntax Check Button)?
Posted: Sat Mar 21, 2020 7:58 am
by Jon
There will be some improvements in the next update.
Jon
Sonny Software
Re: Request: On SQL Error -> to Editor (or Syntax Check Button)?
Posted: Sun Mar 22, 2020 1:41 pm
by DrJJWMac
It would also be extremely helpful when the SQL/Regex Search dialog input window would NOT close automatically with clicking the Search button. The process to test and retest and test yet again has become a tedium of opening and re-opening and re-opening again on that dialog window.
--
JJW
Re: Request: On SQL Error -> to Editor (or Syntax Check Button)?
Posted: Sun Mar 22, 2020 3:53 pm
by Jon
No, searches of course will be done when press the Search button. Please wait to see the improvements in the next update and then complain.
Jon
Sonny Software