Request: On SQL Error -> to Editor (or Syntax Check Button)?

A place for users to ask each other questions, make suggestions, and discuss Bookends.
Post Reply
DrJJWMac
Posts: 35
Joined: Sat Jun 22, 2019 8:04 am
Location: south east USA

Request: On SQL Error -> to Editor (or Syntax Check Button)?

Post by DrJJWMac » Fri Mar 20, 2020 7:13 pm

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

Jon
Site Admin
Posts: 8454
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: Request: On SQL Error -> to Editor (or Syntax Check Button)?

Post by Jon » Sat Mar 21, 2020 7:09 am

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

Jon
Site Admin
Posts: 8454
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: Request: On SQL Error -> to Editor (or Syntax Check Button)?

Post by Jon » Sat Mar 21, 2020 7:58 am

There will be some improvements in the next update.

Jon
Sonny Software

DrJJWMac
Posts: 35
Joined: Sat Jun 22, 2019 8:04 am
Location: south east USA

Re: Request: On SQL Error -> to Editor (or Syntax Check Button)?

Post by DrJJWMac » Sun Mar 22, 2020 1:41 pm

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

Jon
Site Admin
Posts: 8454
Joined: Tue Jul 13, 2004 6:27 pm
Location: Bethesda, MD
Contact:

Re: Request: On SQL Error -> to Editor (or Syntax Check Button)?

Post by Jon » Sun Mar 22, 2020 3:53 pm

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

Post Reply