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