|
|
Posted by grant on 05/29/07 22:50
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.
Navigation:
[Reply to this message]
|