Re: [dtp-dev] Adhoc sql editor

[Hui.Cao@xxxxxxxxxx]

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