SQL Power Software Forum

Views. I would like to be able to model my views with the ability to enter the code that creates the view. Also should include the reverse engineering of views and forward engineering as well. Maybe differentiate the look of the view on the model too.

Thanks for the idea!

One feature that would be useful for me is the ability to pre-defined column names. Some organizations have standards for column naming for say column level metadata with for example a LOAD_DATE, UPDATE_DATE, CURRENT_IND and many more. Instead of having to redefine these columns for every table it would be useful to create it once as a 'pre-defined column' and then select / drag that column when appropriate for a table.

When re-arranging columns PA is not allowing me to move a column to the bottom of the table. Instead I have to move it to second last and then move the last to the second last making the one I want last that actual last one.

Minor Suggesiton:

I would like to be able to have different columns within the same table have different colours. Typically I have used this in the past to differentiate visually primary keys, foreign keys, and changes to the model.

Thanks!

When trying to connect to an Oracle database I get the following error after clicking test connection:

Exception type: java.sql.SQLException

Detail string: JDBC Driver "oracle.jdbc.OracleDriver" not found.

What might be the cause? How do I resolve?

The prev and next query buttons are useful. I would also not mind seeing:

1 - some sort of list select of previous queries
2 - the ability to open up multiple query window/tabs

I tried to create a table using the Wabit SQL Window on the demo database. It said I could not do this as it was in read only mode. Can this be changed?

In Wabit when does a commit occur? Is it automatic? Am I able to rollback?

Probably not a required function in a BI tool but if someone was using the Wabit as a general query tool control of this would be useful.

In the query window if I have multiple queries, say something simple like:

SELECT * FROM Movie ;

SELECT Title, Year, Genre FROM Movie ;

SELECT DISTINCT First_Name, Last_Name FROM Actor;

The behviour I see is that the last query is run, even if I highlight one of the earlier ones. The behaviour I would expect and like to see is:

- If I do not highlight a specific query it runs all of the queries with a way to switch back and forth between results

- If I highlight a query(ies) it runs only that query(ies) and dislplays them

This is a fairly typicaly behaviour in my experience with query tools.

Jason

Not sure about the majority but that is what I do ... and still see to do

As Jeff illustrates we all probably have different instincts to some extent.

OK - well it is good the funtionality.

I think the naming and usability could be improved somehow - I will think about it and try to offer some good suggestions.

I don't think the column size auto adjustment would always be welcome either - I would not want it to do it

sure, this may be totally not correct in how to do a calculated value but should clarify what I am trying to do

It did give a warning - sorry for not being so clear.

What i wanted to do was make changes in the query and then go back to the query pen to see how the query changes change what is in the query pen - I can see how this might be fairly complex to do but it is what I would expect to be able to do.