Posted by Martijn Tonies on 05/30/07 15:34

> If I build a view that includes a calculated field using a custom
> function, and have another view thats built on the first one, then
> change the function to produce a different result, the second view
> dosnt show the new value, its shows the old value. I have to cut the
> sql statment from the view and then paste it back in and save it on
> both views before the data is refreshed correctly.
>
> Has anyone else found this??
>
> Surely there are some better tools out there to replace Enterprise
> Manager for building views and SQL statements graphcally?

Database Workbench - www.upscene.com

Using the two-way Visual Query Builder, you should be able to come
a long way:
http://www.upscene.com/documentation/dbw/tools_visualquerybuilder.htm


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

• Next in forum: Re: Need Help with a SQL Statement - Trying not to use a Cursor
• Prev in forum: Re: sorting table while inserting
• Thread view: Re: SQL Enterprise Manager - Not very usefull tool for building views

[Reply to this message]