SqlDbx
You are not logged in.
Pages: 1
There is a Find All enhancement I would LOVE to see...
Right now it returns the row number and the data in that row.
Could you add a new column that shows the object name from which the result came? That would bring tremedous value because sometimes we research a few thousands rows, and want to whittle down to certain objects that contains the value being searched.
Thanks,
Jason Lipman
Oh, and also, it would be great to be able to dbl-clk the results of the Find All, at the bottom of the screen, and it opens an Edit session.
Jason Lipman
I am not sure what you mean.
Are you talking about Find All in script and then
try to figure out if it was inside create table or procedure?
What if script does not have create statements but only select and executes?
Not sure how feasible is to implement something like this.
What about search in database? It looks to me it will do the same.
Offline
I apologize for being unclear. It was a busy day! I blended two enhancements incoherently into one!
(1)
When using <Tools><Search In Database>, and also the "Script to Active Editor Window", all the objects write to the window.
THEN, in the window, we use <Ctrl><F> to find something in all the scripts, and utilize "Find All" in the popup. It would be
very helpful if the "Find All" results include which object for which that row belongs. For example, searching for the word "testword"...
Currently...
Line Text
---- ------------------
1 testword
123 testword
1529 testword
Enhancement...
Line Text Object
---- ------------------ -------------------------
1 testword Table: tablename
123 testword View: viewname
1529 testword Proc: pr_procname_sp1
(2)
When using <Tools><Search In Database>, the results show up at the bottom of the window.
At the bottom, it would be helpful to dbl-click, or an option in Rt-click, to open the found object
in it's own tab.
Jason Lipman
Thank you for clarification.
I think something like this can be useful.
Offline
Pages: 1