Re: [dtp-dev] Adhoc sql editor

[jograham@xxxxxxxxxx]

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