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

On May 30, 10:34 am, g... (AT) technologyworks (DOT) co.nz wrote:
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.

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