Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [dtp-dev] Adhoc sql editor

That reminds me, when I use editor with id "oracle.dbtools.editor.sql.SQLEditor", (SQLEditor instance) does not have the context menu item, "Set Connection Info" whereas one corresponding to "org.eclipse.datatools.sqltools.internal.sqlscrapbook.editor.SQLScrapboo kEditor" (SQLScrapbookEditor instance) seems to have it.

Anthos
On 27/10/2006, at 7:01 AM, jograham@xxxxxxxxxx wrote:

Hi Anthos,

Yes, I did that, but the actions mentioned below are not present on the
context menu.

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Staff Software Engineer, Sybase, Inc.
http://dataplat.blogspot.com/




             Anil Samuel
             <anil.samuel@orac
le.com> To
             Sent by:                  DTP development mailing list
             dtp-dev-bounces@e         <dtp-dev@xxxxxxxxxxx>
clipse.org cc

Subject
             10/26/2006 04:38          Re: [dtp-dev] Adhoc sql editor
             PM


             Please respond to
              DTP development
               mailing list
             <dtp-dev@eclipse.
                   org>






One needs to do "Set Connection Info" before Execute.

Anthos
On 27/10/2006, at 1:23 AM, jograham@xxxxxxxxxx wrote:

Hi Hui:

Yes, that what I mean. I've entered the following bug for it:

https://bugs.eclipse.org/bugs/show_bug.cgi?id=162243

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Staff Software Engineer, Sybase, Inc.
http://dataplat.blogspot.com/




             Hui.Cao@xxxxxxxxx
             m
             Sent
by:                                                   To
             dtp-dev-bounces@e         DTP development mailing list
             clipse.org                <dtp-dev@xxxxxxxxxxx>

  cc

             10/26/2006 02:48
Subject
             AM                        Re: [dtp-dev] Adhoc sql editor


             Please respond to
              DTP development
               mailing list
             <dtp-dev@eclipse.
                   org>







Hi John,
        Do you mean you can't "Execute selected text" or "Execute
All" in
SQL Editor? If so, this is apparently a bug and I'll look into it
ASAP. Do
you have the BZ number?

Best Regards!

Max ( Hui ) Cao
Sybase, Inc. Shanghai, China



 jograham@xxxxxxxxxx


 10/25/2006 11:50
PM                                                    To
                                        DTP development mailing list
                                        <dtp-dev@xxxxxxxxxxx>

  cc


Subject
Re: [dtp-dev] Adhoc sql editor












I think there is a real need to have a component in DTP that allows
for
simple, ad-hoc queries against a database connection profile. Most
likely
this would be a view exposing the same functionality as today's SQL
Editor,
but without the need to associate it with a file in any manner. (Of
course,
having the ability to save the contents into a file would be great
too.)

Also, I notice in recent builds that it is becoming harder to
simply create
a sql file and try out some queries. Whereas before I could "Execute
selected text" or "Execute All" on the editor context menu, now we
apparently have to set a "adhoc sql" launch configuration, which is
a lot
more trouble.

I'd like to ask that the SQL Dev team considers these issues along
with
community input to get a resolution in the 1.0 time frame.

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Staff Software Engineer, Sybase, Inc.
http://dataplat.blogspot.com/




            Hui.Cao@xxxxxxxxx
            m
            Sent
by:                                                   To
            dtp-dev-bounces@e         DTP development mailing list
            clipse.org                <dtp-dev@xxxxxxxxxxx>

 cc

            10/25/2006 12:25
Subject
            AM                        Re: [dtp-dev] Adhoc sql editor


            Please respond to
             DTP development
              mailing list
            <dtp-dev@eclipse.
                  org>







Hi Anthos,
The sqlscrapbook plugin name is misleading. Although it's named
"scrapbook", in fact it's handling sql files. This name comes from
WTP RDB
when we align with RDB efforts during the initial stage of DTP. It
should
be renamed to sqlfileeditor instead. Please open a bug entry for this
problem.
       Back to your question, to open a sql editor which is not
backed by
a file, you can use SQLEditor with an instance of
SQLEditorStorageEditorInput.

Best Regards!

Max ( Hui ) Cao
Sybase, Inc. Shanghai, China



Anil Samuel <anil.samuel@xxxxxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx

 To
                                                            dtp-
dev@eclip
10/25/2006 11:40 AM                                         se.org

 cc

              Please respond to
Subject
        DTP development mailing list                        [dtp-dev]
            <dtp-dev@xxxxxxxxxxx>                           Adhoc sql
                                                            editor












Hi

How do I open a (ScrapbookEditor) SQL Editor to edit a adhoc/
dynamically
generated SQL ?
The ScrapbookEditorInput class is internal; so not available to
external
plugins.

Note that the editor is not backed by a IFile instance when it is
started. Also should let user to save as usual.

Regards
Anthos
_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev

_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev


_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev


_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev

_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev



_______________________________________________
dtp-dev mailing list
dtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/dtp-dev



Back to the top