Syntax case

[William Robertson]

This is a small nitpick but it bothers me.

When I right-click a table or view and select 'Query data', a default query is run in a new SQL window. Since it's just the default 'select * from ...', my keyword case capitalisation preference is not applied to it (fair enough). However, I often go on to add further conditions manually (or using Query By Example), resulting in a query that starts all lowercase and ends with keywords in uppercase, which then bothers me and I have to go back and highlight the first line to apply syntax case. Could this not be applied automatically?

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Stew Stryker]

If we're talking about nits in this area...

I wish instead of doing a "SELECT * FROM ..."

it provided the table columns in the query, so I can remove the ones I don't want. I know I can get the values from Describe. It's just an extra step (and something SQL/Naviagator does by default).

Thanks,

Stew

 

[whip]

You can drag and drop the table name from the browser and click on 'Select' in the menu appearing.