Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » How to launch SQL Editor
How to launch SQL Editor [message #45840] Fri, 27 June 2008 01:46 Go to next message
Eclipse UserFriend
Originally posted by: hypertree.yahoo.com

Folks,

Last time it took me hours to figure how to launch SQL Editor in WTP 2.0
(right click on connection in Data Source Explorer -> Database and select
New SQL Editor or something similar). Now I am using Eclipse 3.4 JavaEE
edition and this option doesn't seem to exist. Though I see options to
configure it in preferences section.

How do you start a SQL editor to run ad hoc sqls ? (I don't want to open
file).

I would be nice if this crucial feature was made more accessible to end
users who are not DTP officianados.

thank you,

-Sanjay
Re: How to launch SQL Editor [message #45900 is a reply to message #45840] Mon, 30 June 2008 05:29 Go to previous message
Eclipse UserFriend
Originally posted by: hui.cao.sybase.ocm

Hi Sanjay,
Open "Database Development" perspective and you'll see a "SQL Scrapbook"
workbench toolbar button, via which you can run ad hoc sqls without having
to open files. To configure the default connection info for the scrapbook,
go to Preferences->Database Development->SQL Editor->SQL Files/Scrapbooks.
Alternatively, if you select one connection profile before you invoke the
SQL Scrapbook, it'll override the default connection preference setting.
Please let me know whether these features fit your need. Thanks.

--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD
"Sanjay Kumar" <hypertree@yahoo.com> wrote in message
news:d4921225a7663191658ef54c11cc7fdc$1@www.eclipse.org...
> Folks,
>
> Last time it took me hours to figure how to launch SQL Editor in WTP 2.0
> (right click on connection in Data Source Explorer -> Database and select
> New SQL Editor or something similar). Now I am using Eclipse 3.4 JavaEE
> edition and this option doesn't seem to exist. Though I see options to
> configure it in preferences section.
>
> How do you start a SQL editor to run ad hoc sqls ? (I don't want to open
> file).
>
> I would be nice if this crucial feature was made more accessible to end
> users who are not DTP officianados.
>
> thank you,
>
> -Sanjay
>
Re: How to launch SQL Editor [message #591607 is a reply to message #45840] Mon, 30 June 2008 05:29 Go to previous message
Hui Cao is currently offline Hui CaoFriend
Messages: 29
Registered: July 2009
Junior Member
Hi Sanjay,
Open "Database Development" perspective and you'll see a "SQL Scrapbook"
workbench toolbar button, via which you can run ad hoc sqls without having
to open files. To configure the default connection info for the scrapbook,
go to Preferences->Database Development->SQL Editor->SQL Files/Scrapbooks.
Alternatively, if you select one connection profile before you invoke the
SQL Scrapbook, it'll override the default connection preference setting.
Please let me know whether these features fit your need. Thanks.

--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD
"Sanjay Kumar" <hypertree@yahoo.com> wrote in message
news:d4921225a7663191658ef54c11cc7fdc$1@www.eclipse.org...
> Folks,
>
> Last time it took me hours to figure how to launch SQL Editor in WTP 2.0
> (right click on connection in Data Source Explorer -> Database and select
> New SQL Editor or something similar). Now I am using Eclipse 3.4 JavaEE
> edition and this option doesn't seem to exist. Though I see options to
> configure it in preferences section.
>
> How do you start a SQL editor to run ad hoc sqls ? (I don't want to open
> file).
>
> I would be nice if this crucial feature was made more accessible to end
> users who are not DTP officianados.
>
> thank you,
>
> -Sanjay
>
Previous Topic:ecore ODA - dependencies for driver?
Next Topic:Flat files in DTP?
Goto Forum:
  


Current Time: Mon Nov 24 20:16:12 GMT 2014

Powered by FUDForum. Page generated in 0.01981 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software