469,948 Members | 2,591 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,948 developers. It's quick & easy.

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

May 29 '07 #1
2 1974
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.


May 29 '07 #2
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...erybuilder.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
May 30 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

By using this site, you agree to our Privacy Policy and Terms of Use.