[jbee]

Hey,
I am using the Database Explorer and when I preview a table, in the TableInfo:Preview pane, all I get are the first 100 rows of the table, as per the settings. However, as the table gets used I am more interested, more often then not, in the later records and have to revert to an SQL Query window.

I would like to know whether it is possible to alter the behaviour to either increase the number of rows returned, to a really high number or to preview the last 100 records.

Thanks.

[snpe]

see preferences

[Riyad Kalla]

jbee, as snpe correctly pointed out, you can change these settings under Window > Preferences > MyEclipse > DB Explorer

[jbee]

thanks for your responses.

Unfortunately, my problem is not resolved. I am aware of the preferences which is what i was implying by ‘as per the settings’, sorry if this didn’t get across.

The problem is that the preview limit is 100 records. So if there is a table with say 150 records, you only see the first 100. As you are developing and the table is getting filled more and more you are normally interested in the most recently added records. It is those records that I would like to be able to see in the Preview Pane. Otherwise this view is not very useful for any table that contains more than 100 records.

once again tia

[Riyad Kalla]

hmm… interesting request, I’ll pass it along to the developer of this and see if there is a generic way to SELECT the last 100 inserted records… if not, then this probably won’t happen.

[snpe]

You have icon in toolbar of ‘sql results’ view – retrieve all rows

Maximum is 5000 rows (in preferences)

regards

[support-jeff]

You can also select the table in the database navigator, right-click and Create Select Statement, and add an ORDER BY to the query to get what you want. I know its a bit more work, but the use case you present is not an ordinary one (at least IMHO and experience).

[snpe]

Jeff,
You can drop limit on 5000 rows (if user set more rows and get out of memory it is user’s problem – maybe that set warning in preferences)

regards

[support-jeff]

snpe –

Not sure I totally follow the reasoning. Are you saying that we should drop the SQL Row Limit preference altogether and replace it with a warning? If so, I do not understand the motivation. If it is to give users an option to make queries unlimited, I can see a checkbox (or set limit to 0) for unlimited rows.

[snpe]

You don’t understand me
I want limit, but not constraint to 5000 rows (in preferences) – when user change this limit (without constraint) in preferences then ME can warn user for possible out of memory
I use scrollable resultset in production for table with large rows and then limit isn’t important because application have only xxx (i prefer 100) rows in memory and fetch another from database for request

regards

[support-jeff]

ok – sorry, now am understandink. I did not realize that the SQLExplorer plugin on which the ME DB Explorer is based had a maximum allowed limit of 5000. That is definitely worth fixing. I will add an issue for this.

[jbee]

Hey, just to get back on track, my original question was about the TableInfo:PreView Tab _not_ the SQL Preview Pane.

The scenario is that I am doing some DBUnit testing. My code runs and puts some stuff into the table. DBUnit checks this and flags a test Failiure. I want to inspect what went into the table.

I could, of course, do an SQL query and look in the SQL Preview pane. By the time I write this I may as well have some constraints and I wouldn’t have a problem. But say I don’t want to write a query for a quick look; the data _is_ in the table as the last inserted records and I have this preview facility anyway. The problem is that the preview looks at the first 100 records which, to all extents and purposes, will remain the same and I’m interested in the last 100+
Think unix ‘tail’ and you’ll get the idea.

Thanks.

[Riyad Kalla]

jbee,
I believe Jeff addressed this and there is no universal way to do this, atleast that is what I understood his concern to be.

[Author]

Posts