SQL Enterprise Manager - Not very usefull tool for building views

Man do I struggle with Enterprise Manager as a graphical tool for
building views etc.

Its flaky and hangs frequenlty so i have to kill it with the task
manager and re open it.

You cant debug functions ( or am I missing something)

But the worst thing is that it appears to cache the results of views
and doesnt refresh from the source.

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?

Cheers

Grant

Re: SQL Enterprise Manager - Not very usefull tool for building views

On May 30, 10:34 am, g...@technologyworks.co.nz wrote:
> Man do I struggle with Enterprise Manager as a graphical tool for
> building views etc.
>
> Its flaky and hangs frequenlty so i have to kill it with the task
> manager and re open it.
>
> You cant debug functions ( or am I missing something)
>
> But the worst thing is that it appears to cache the results of views
> and doesnt refresh from the source.
>
> 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?
>
> Cheers
>
> Grant

I take some if this back... The cacheing issue I have been
experienceing is using an MS Access ADP project, so may not be an
Enterprise Manager issue.

Re: SQL Enterprise Manager - Not very usefull tool for building views

> 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_visualquerybu ilder.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