Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » How to open the SQL Editor?
How to open the SQL Editor? [message #17959] Wed, 28 June 2006 09:14 Go to next message
Lee Parson is currently offline Lee ParsonFriend
Messages: 2
Registered: July 2009
Junior Member
Hello!

I have download the DTP 0.9 and could connect to various
databases(Derby,Oracle,MySql,and so on) throuth jdbc, when I navigate to DSE
perspective, I can see the "Result View" and "Scrpit History" ,but I can not
find the "SQL Editor",where can i open it?

By the way, the editor can be opened from the pop-up menu item "Edit..."
when a function or procedure is selected in the DSE tree, and I can performe
SQL execution there.

Thanks
-Parson
Re: How to open the SQL Editor? [message #17985 is a reply to message #17959] Wed, 28 June 2006 18:07 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jograham.sybase.com

Lee Parson wrote:

> Hello!

> I have download the DTP 0.9 and could connect to various
> databases(Derby,Oracle,MySql,and so on) throuth jdbc, when I navigate to DSE
> perspective, I can see the "Result View" and "Scrpit History" ,but I can not
> find the "SQL Editor",where can i open it?

> By the way, the editor can be opened from the pop-up menu item "Edit..."
> when a function or procedure is selected in the DSE tree, and I can performe
> SQL execution there.

> Thanks
> -Parson

Hi Parson,

The easiest thing to do is create a new .sql file (New-->SQL
Development-->SQL File).

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Re: How to open the SQL Editor? [message #18061 is a reply to message #17985] Fri, 30 June 2006 07:05 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: zkoppany.gmx.de

But I don't wnt to create a new file, I just want to execute queries.

Zsolt

"John Graham" <jograham@sybase.com> schrieb im Newsbeitrag
news:b2beff71c61f25edd5c30dec45c079ba$1@www.eclipse.org...
> Lee Parson wrote:
>
>> Hello!
>
>> I have download the DTP 0.9 and could connect to various
>> databases(Derby,Oracle,MySql,and so on) throuth jdbc, when I navigate to
>> DSE perspective, I can see the "Result View" and "Scrpit History" ,but I
>> can not find the "SQL Editor",where can i open it?
>
>> By the way, the editor can be opened from the pop-up menu item "Edit..."
>> when a function or procedure is selected in the DSE tree, and I can
>> performe SQL execution there.
>
>> Thanks
>> -Parson
>
> Hi Parson,
>
> The easiest thing to do is create a new .sql file (New-->SQL
> Development-->SQL File).
>
> Regards,
> John Graham
> Eclipse Data Tools Platform PMC Chair
>
>
Re: How to open the SQL Editor? [message #18074 is a reply to message #18061] Fri, 30 June 2006 11:52 Go to previous message
Eclipse UserFriend
Originally posted by: raghvendra.saboo.gmail.com

A related issue is here:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=6038

There had been talks to free up the editor framework from resource
framework and still supporting all the rich editing features, don't know
whats the status now.

The scrapbook editor has a associated "connection", and persisting the
scrapbook contents and connection should be an option, not a mandate.

Wish there is a toolbar button in Database Dev. perspective, to launch sql
scrapbook, and a context menu in DSE doing the same. It should create a
scrapbook with default name (and store it in meta-data folder if editor
can't work with streams). Should ask for saving only on closing the
scrapbook, with a "remember-my-choice" preference checkbox.

File->New-->Others-->SQL Development-->SQL File should still be there, but
Database Dev. perspective could shorten it to File->New->SQL File.

Regards,
Raghu

Zsolt Koppany wrote:

> But I don't wnt to create a new file, I just want to execute queries.

> Zsolt

> "John Graham" <jograham@sybase.com> schrieb im Newsbeitrag
> news:b2beff71c61f25edd5c30dec45c079ba$1@www.eclipse.org...
>> Lee Parson wrote:
>>
>>> Hello!
>>
>>> I have download the DTP 0.9 and could connect to various
>>> databases(Derby,Oracle,MySql,and so on) throuth jdbc, when I navigate to
>>> DSE perspective, I can see the "Result View" and "Scrpit History" ,but I
>>> can not find the "SQL Editor",where can i open it?
>>
>>> By the way, the editor can be opened from the pop-up menu item "Edit..."
>>> when a function or procedure is selected in the DSE tree, and I can
>>> performe SQL execution there.
>>
>>> Thanks
>>> -Parson
>>
>> Hi Parson,
>>
>> The easiest thing to do is create a new .sql file (New-->SQL
>> Development-->SQL File).
>>
>> Regards,
>> John Graham
>> Eclipse Data Tools Platform PMC Chair
>>
>>
Re: How to open the SQL Editor? [message #580167 is a reply to message #17959] Wed, 28 June 2006 18:07 Go to previous message
John Graham is currently offline John GrahamFriend
Messages: 183
Registered: July 2009
Senior Member
Lee Parson wrote:

> Hello!

> I have download the DTP 0.9 and could connect to various
> databases(Derby,Oracle,MySql,and so on) throuth jdbc, when I navigate to DSE
> perspective, I can see the "Result View" and "Scrpit History" ,but I can not
> find the "SQL Editor",where can i open it?

> By the way, the editor can be opened from the pop-up menu item "Edit..."
> when a function or procedure is selected in the DSE tree, and I can performe
> SQL execution there.

> Thanks
> -Parson

Hi Parson,

The easiest thing to do is create a new .sql file (New-->SQL
Development-->SQL File).

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Re: How to open the SQL Editor? [message #580303 is a reply to message #17985] Fri, 30 June 2006 07:05 Go to previous message
Eclipse UserFriend
Originally posted by: zkoppany.gmx.de

But I don't wnt to create a new file, I just want to execute queries.

Zsolt

"John Graham" <jograham@sybase.com> schrieb im Newsbeitrag
news:b2beff71c61f25edd5c30dec45c079ba$1@www.eclipse.org...
> Lee Parson wrote:
>
>> Hello!
>
>> I have download the DTP 0.9 and could connect to various
>> databases(Derby,Oracle,MySql,and so on) throuth jdbc, when I navigate to
>> DSE perspective, I can see the "Result View" and "Scrpit History" ,but I
>> can not find the "SQL Editor",where can i open it?
>
>> By the way, the editor can be opened from the pop-up menu item "Edit..."
>> when a function or procedure is selected in the DSE tree, and I can
>> performe SQL execution there.
>
>> Thanks
>> -Parson
>
> Hi Parson,
>
> The easiest thing to do is create a new .sql file (New-->SQL
> Development-->SQL File).
>
> Regards,
> John Graham
> Eclipse Data Tools Platform PMC Chair
>
>
Re: How to open the SQL Editor? [message #580332 is a reply to message #18061] Fri, 30 June 2006 11:52 Go to previous message
Raghu is currently offline RaghuFriend
Messages: 19
Registered: July 2009
Junior Member
A related issue is here:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=6038

There had been talks to free up the editor framework from resource
framework and still supporting all the rich editing features, don't know
whats the status now.

The scrapbook editor has a associated "connection", and persisting the
scrapbook contents and connection should be an option, not a mandate.

Wish there is a toolbar button in Database Dev. perspective, to launch sql
scrapbook, and a context menu in DSE doing the same. It should create a
scrapbook with default name (and store it in meta-data folder if editor
can't work with streams). Should ask for saving only on closing the
scrapbook, with a "remember-my-choice" preference checkbox.

File->New-->Others-->SQL Development-->SQL File should still be there, but
Database Dev. perspective could shorten it to File->New->SQL File.

Regards,
Raghu

Zsolt Koppany wrote:

> But I don't wnt to create a new file, I just want to execute queries.

> Zsolt

> "John Graham" <jograham@sybase.com> schrieb im Newsbeitrag
> news:b2beff71c61f25edd5c30dec45c079ba$1@www.eclipse.org...
>> Lee Parson wrote:
>>
>>> Hello!
>>
>>> I have download the DTP 0.9 and could connect to various
>>> databases(Derby,Oracle,MySql,and so on) throuth jdbc, when I navigate to
>>> DSE perspective, I can see the "Result View" and "Scrpit History" ,but I
>>> can not find the "SQL Editor",where can i open it?
>>
>>> By the way, the editor can be opened from the pop-up menu item "Edit..."
>>> when a function or procedure is selected in the DSE tree, and I can
>>> performe SQL execution there.
>>
>>> Thanks
>>> -Parson
>>
>> Hi Parson,
>>
>> The easiest thing to do is create a new .sql file (New-->SQL
>> Development-->SQL File).
>>
>> Regards,
>> John Graham
>> Eclipse Data Tools Platform PMC Chair
>>
>>
Previous Topic:New Data Set - Incomplete database results
Next Topic:DTP 0.9 Released!
Goto Forum:
  


Current Time: Thu Sep 26 03:44:55 GMT 2024

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

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

Back to the top