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: 346
Joined: Sat Jun 22, 2019 8:04 am
Location: Alabama USA

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

Post 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
--
JJW
Jon
Site Admin
Posts: 10061
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 »

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: 10061
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 »

There will be some improvements in the next update.

Jon
Sonny Software
DrJJWMac
Posts: 346
Joined: Sat Jun 22, 2019 8:04 am
Location: Alabama USA

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

Post 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
--
JJW
Jon
Site Admin
Posts: 10061
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 »

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