[jarethk]

Let me first say I LOVE your database explorer! Would it be possible to have more than 1 SQL Results window? Right now (as in this instant) I’ve got 3 sql files open doing different queries and cross-referencing them. This would be a lot easier to do if there were 1 SQL Result for each query, or 1 tab within that view for each query. Thanks and keep up the great work!!

— David F.

[Riyad Kalla]

David thank you for the compliments, I will pass your request onto the dev… IIRC he already has this enhancement files, but we’ll make sure 😉

[support-jeff]

Yep, the request is already in bugzilla. Currently you get multiple results panels in the SQL Results View if you execute multiple statements in a single go. That is a arguably a common use case, but executing multiple statements *individually* over a timespan is far more common – and you might want to compare the various results in some way. So, again, the request is in there. Just keep making the request so we get sick of hearing about it and fix it! 😉

[coemergence]

I would make use of this too, if I had the ability.

John@Coemergence

[Dennis]

It has my vote also… This would be very useful.

[orrick]

Please add this feature !!!

[rkbalan]

Hi,

This seems to be an old request. Has it been implemented? The
MyEclipse version I’m using is-

Version: 5.1.1 GA
Build id: 20070302-5.1.1-GA

If yes, please advise me how to open multiple SQL results tabs.
I’ve looked on the help menu and searched the FAQs already.

TIA,

– rkb.

[Haris Peco]

rkb,

You can just call Run in SQL editor and MyEclipse will execute all your queries and presents result in more tabs in SQL Result view.
If you have statements which return more result sets (for instance, stored procedures in SQl Server/Sybase or other database which support that) you will got more tabs as well.

Regards,

[rkbalan]

Peco,

I think I may have not explained what I was hoping to achieve-

I have 2 SQL editors open, with different files, each connected to a different
database (or schema). Then, I execute a query in one of the editors and I
have the SQL results show up. Now, if I switch to the second editor and run
a query, the original SQL results is overwritten (my objective here was to try
to query 2 different databases and compare the results). Is it possible to do
something like this? Any help would be appreciate (ps: I am a novice when
it comes to databases and might be completely doing something incorrect)

Thanks,

-rkb.

[Haris Peco]

rkb,

It is not possible in currently MyEclipse.I will make request for enhancements

Regards,

[Author]

Posts