Re: [dtp-dev] Adhoc sql editor

[Hung.Hsi@xxxxxxxxxx]

We will consider this suggestion and try to accommodate it in DTP 1.0
timeframe. Please open a bug.

Thanks and regards,
Hung


                                                                           
             jograham@sybase.c                                             
             om                                                            
                                                                        To 
             10/25/2006 08:50          DTP development mailing list        
             AM                        <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