× 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.



Thanks All, I Found It. What's the benefit over using STRSQL?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Friday, September 21, 2007 12:34 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL Finding & Using -- iNav Run SQL

After getting to the Databases icon, or having done Open on the
Databases icon for a given system, I just use a right-click on the
specific database I want [from the list], to get to the Run SQL. No
need to continue to expand to get to the Schemas.

I originally had thought it was odd that the Run SQL feature was not
directly available from the Databases icon, with just a right-click.
However when a system has multiple databases defined in WRKRDBDIRE [for
some, perhaps only due to multiple iASP], I realized why the UI insisted

I had to select a database first, to get the Run SQL. However IMO an
improved UI would still let me right-click the Databases icon to get the

option to Run SQL, and then if I had to choose a database, present a
list or perhaps 'connect to' dialog box with an input field having an
optional pull-down list -- or it could even place me in the scripting
session, leaving it in an unconnected state, so I start muttering at my
screen about how stupid the sfw is for not knowing what I wanted ;-)

Regards, Chuck

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.