Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Some handling questions
Some handling questions [message #30552] Sat, 05 May 2007 06:45 Go to next message
Eclipse User
Originally posted by: san.ixdb.de

Hello DTP friends ;)

i've some more questions:

- How can i configure a statement separator for using in a SQL Editor ?

- I missing some timing information to see how long it takes to execute
a sql statement.

The handling of the SQL history and the results are a little confusing.
For example: if i open two files, each editor is connected to another
server/database, the results are listed on the same SQL Results Page,
thats very confusing.
I think are more common way is to have for each editor a own Results
Page and perhaps only one SQL History with information about the used
connection?

- SQL Editor: I missing some Toolbar Buttons e.g.:
Commit/rollback/execute/execute next/execute all/...
I've see that there is a enhancement request for a toolbar but, i found
nothing about the planned actions to put on it. I like it to hit F5 for
executing the current statement, like in the MS SQL Servers Query
Analyzer ;)

- "SQL Abbreviations:" Is there a plan to implement abbreviations? So i
can typ "se<SPACE>" and the appliaction complete it to "SELECT * FROM ".

DTP is a great tool and i believe it has the power to getting better.

Andreas
Re: Some handling questions [message #33600 is a reply to message #30552] Fri, 27 July 2007 02:18 Go to previous message
Eclipse User
Originally posted by: hui.cao.sybase.ocm

Hi Andreas,
Please see inline comments below:

--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD

"Andreas Schneider" <san@ixdb.de> wrote in message
news:f1hn7d$qsf$1@build.eclipse.org...
> Hello DTP friends ;)
>
> i've some more questions:
>
> - How can i configure a statement separator for using in a SQL Editor ?
There has been a discussion about this problem in the mailing list:
http://dev.eclipse.org/mhonarc/lists/dtp-dev/msg01341.html

>
> - I missing some timing information to see how long it takes to execute a
> sql statement.
That's a good suggestion, please fire an enhancement request on bugzilla:
http://bugs.eclipse.org/bugs/.

>
> The handling of the SQL history and the results are a little confusing.
> For example: if i open two files, each editor is connected to another
> server/database, the results are listed on the same SQL Results Page,
> thats very confusing.
> I think are more common way is to have for each editor a own Results Page
> and perhaps only one SQL History with information about the used
> connection?
In Eclipse, one type of view can only have one instance. The
consumer/profile columns may help
user to distinguish the SQL statements.

>
> - SQL Editor: I missing some Toolbar Buttons e.g.:
> Commit/rollback/execute/execute next/execute all/...
> I've see that there is a enhancement request for a toolbar but, i found
> nothing about the planned actions to put on it. I like it to hit F5 for
> executing the current statement, like in the MS SQL Servers Query Analyzer
> ;)
F5 in Eclipse has been used as shortcut key for "refresh". We're using
"Alt+X" to
execute selected SQL statements. ( trying not to conflict with other
shortcut keys, not very convenient though )

>
> - "SQL Abbreviations:" Is there a plan to implement abbreviations? So i
> can typ "se<SPACE>" and the appliaction complete it to "SELECT * FROM ".
This is interesting, but what if there's a object called "se"? In DTP,
we have templates to assist user. Try type "se" and press
"Ctrl+Space"/"Alt+/" (depending on your preference),
you should be able to see the "select" template.

>
> DTP is a great tool and i believe it has the power to getting better.
>
> Andreas
Re: Some handling questions [message #586881 is a reply to message #30552] Fri, 27 July 2007 02:18 Go to previous message
Hui Cao is currently offline Hui Cao
Messages: 29
Registered: July 2009
Junior Member
Hi Andreas,
Please see inline comments below:

--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD

"Andreas Schneider" <san@ixdb.de> wrote in message
news:f1hn7d$qsf$1@build.eclipse.org...
> Hello DTP friends ;)
>
> i've some more questions:
>
> - How can i configure a statement separator for using in a SQL Editor ?
There has been a discussion about this problem in the mailing list:
http://dev.eclipse.org/mhonarc/lists/dtp-dev/msg01341.html

>
> - I missing some timing information to see how long it takes to execute a
> sql statement.
That's a good suggestion, please fire an enhancement request on bugzilla:
http://bugs.eclipse.org/bugs/

>
> The handling of the SQL history and the results are a little confusing.
> For example: if i open two files, each editor is connected to another
> server/database, the results are listed on the same SQL Results Page,
> thats very confusing.
> I think are more common way is to have for each editor a own Results Page
> and perhaps only one SQL History with information about the used
> connection?
In Eclipse, one type of view can only have one instance. The
consumer/profile columns may help
user to distinguish the SQL statements.

>
> - SQL Editor: I missing some Toolbar Buttons e.g.:
> Commit/rollback/execute/execute next/execute all/...
> I've see that there is a enhancement request for a toolbar but, i found
> nothing about the planned actions to put on it. I like it to hit F5 for
> executing the current statement, like in the MS SQL Servers Query Analyzer
> ;)
F5 in Eclipse has been used as shortcut key for "refresh". We're using
"Alt+X" to
execute selected SQL statements. ( trying not to conflict with other
shortcut keys, not very convenient though )

>
> - "SQL Abbreviations:" Is there a plan to implement abbreviations? So i
> can typ "se<SPACE>" and the appliaction complete it to "SELECT * FROM ".
This is interesting, but what if there's a object called "se"? In DTP,
we have templates to assist user. Try type "se" and press
"Ctrl+Space"/"Alt+/" (depending on your preference),
you should be able to see the "select" template.

>
> DTP is a great tool and i believe it has the power to getting better.
>
> Andreas
Previous Topic:"SQL Results" Tab
Next Topic:Problems editing functions with Postgres
Goto Forum:
  


Current Time: Sat Apr 19 23:18:53 EDT 2014

Powered by FUDForum. Page generated in 0.03748 seconds