RE: STRSQL -- MIDRANGE-L

Open Source. Like SQuirreL.

http://www.sql-workbench.net/

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Danny Hayes
Sent: Thursday, August 10, 2017 1:46 PM
To: Midrange Systems Technical Discussion
Subject: RE: STRSQL

What is SQL Workbench?

Thanks & Regards,
Danny Hayes
IT-Developer
Genuine Parts Company, APG IT

3100 Windy Hill Road
Atlanta, Georgia 30339
mailto:Danny_Hayes@xxxxxxxxx
(904) 502-2969

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Roger Harman
Sent: Thursday, August 10, 2017 4:23 PM
To: Midrange Systems Technical Discussion (midrange-l@xxxxxxxxxxxx) <midrange-l@xxxxxxxxxxxx>
Subject: [EXT] RE: STRSQL

SQL Workbench. Highlight statement, ALT-R. Done. I love that about it.

Also, making SQL lists for "IN()". Highlight list, Alt-L (custom mapped). Done. My boss about fell over when he saw me do that with a column from Excel of about 200 rows.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Thursday, August 10, 2017 12:40 PM
To: Midrange Systems Technical Discussion
Subject: Re: STRSQL

I like to format my queries to make them more readable. Using the prompter undoes any formatting I've already done. For this reason, I tend to keep a field list open in another session, and copy/paste as needed.

Also, as Vern mentioned, the "function" prompter in STRSQL is extremely basic. If you've been around SQL for more than a few months, you probably would never use it.

- Dan

On Thu, Aug 10, 2017 at 3:29 PM, John R. Smith, Jr. < smith5646midrange@xxxxxxxxx> wrote:

I find I still use STRSQL because I never remember the field names and
I can't prompt in ACS.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD

"This e-mail and any attachments, contain Genuine Parts Company confidential information that is proprietary, privileged, and protected by applicable laws. If you have received this message in error and are not the intended recipient, you should not retain, distribute, disclose or use any of this information and you should destroy this e-mail, any attachments or copies therein forthwith. Please notify the sender immediately by e-mail if you have received this e-mail in error."