Re: [dtp-dev] Adhoc sql editor

[Anil Samuel <anil.samuel@xxxxxxxxxx>]

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