× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Thank you sir. I very much appreciate the info. I have not used that tool. So I'm unfamiliar. But knowing it has that feature is enough. I will figure it out. I see that the ability to "save results" must be configured and is not the default. Looks like this will do the job. Thanks again.


-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Therrien, Paul via WDSCI-L
Sent: Friday, April 28, 2023 10:43
To: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Cc: Therrien, Paul <ptherrien@xxxxxxxxxxx>
Subject: Re: [WDSCI-L] New RDi. Lost my favorite feature.

ACS SQL Client downloads to excel by right-clicking on the results tab and selecting 'Save Results'. Available for quite some time.


-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Elden Fenison
Sent: Friday, April 28, 2023 1:40 PM
To: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] New RDi. Lost my favorite feature.

IBM said "merely updating" was not an option. This is a new version intended for a clean install.

-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of x y
Sent: Friday, April 28, 2023 10:34
To: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] New RDi. Lost my favorite feature.

Not having that problem here. There are some settings for this feature that may have been lost if you did a clean install. I merely updated and didn't lose anything: right-click on the output and "Save results" is open for business.

On Fri, Apr 28, 2023 at 10:18 AM Elden Fenison < Elden.Fenison@xxxxxxxxxxxxxxxxx> wrote:

One of the best features of the built-in SQL editor in the old RDi...
was the ability to easily export results to Excel. iACS doesn't seem to do this.


-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Daniel
Gross
Sent: Friday, April 28, 2023 10:16
To: Rational Developer for IBM i <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] New RDi. Lost my favorite feature.

Well yes - I use the iACS run sql script feature.

Essentially because it’s quite good, has a big library of snippets and
can also run CL commands.

With 1.1.9.2 it even can prompt for “host variables” in the statement
like

where table.col = :myVar

OK - this is old for DBeaver, but new to iACS.

HTH
Daniel


Am 28.04.2023 um 18:50 schrieb Elden Fenison <
Elden.Fenison@xxxxxxxxxxxxxxxxx>:

For me, RDi was my SQL tool of choice. I had several large "scratch
pads" of SQL code that I regularly referred to and executed directly
from RDi. One could set the file association for .sql files to be one
of three built-in SQL tools. These all seem to be gone.

I am guessing that this was not the SQL tool of choice for many, or
else
they would not have removed the feature. What should I be using instead...
Access Client Solutions?


[cid:image001.jpg@01D979B5.CC344780]
Elden Fenison
Programmer/Analyst
Murphy Company
elden.fenison@xxxxxxxxxxxxxxxxx<mailto:elden.fenison@murphyplywood.c
om

541-461-1304

--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/wdsci-l.


--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/wdsci-l.


--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/wdsci-l.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.