| Some handling questions [message #30552] |
Sat, 05 May 2007 06:45  |
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  |
| 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 |
| Eclipse User |
|
|
|
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
|
|
|
Powered by
FUDForum. Page generated in 0.04313 seconds
Home