Cannot Drag and Drop a Field from Connection manager to a worksheet.
jacrFeb 21 2009 — edited Feb 21 2009Hi
I've recently installed the latest version of SQLDEVELOPER (1.5.3) onto winxp.
I used to be able (previous version) to drag fields from the connection manager and drop onto a worksheet to save typing the field name when writing sql.
This new version currently does not allow me to do this (it lets me drag, but not drop).
I am able to drag a table object - and when I drop onto worksheet it creates a select statement with all fields.
Is this by design, or is there a setting in preferences that I'm missing, or could there be something wrong with my installation ?
Another not so good feature on this new version:
When you Right-Click a package object on the connection manager and select "Run" : a window appears with automatically generated plsql block to run the package - great. However I used to be able to copy this plsql and paste it into anything I wanted (e.g. note-pad, or another application etc), but now I am unable to use the generated code unless I use the "Save File.." button. (Copy/paste etc is not available from either "right click", Edit menu or CTRL C).
Again is this by design (I certainly used to be able to do it) or is it a problem specific to my installation.
Any pointers much appreciated.
jacr