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
2  2069 
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.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Paul Brownjohn |
last post by:
Hi Guys
Upon creating and running a view in the SQL Svr 2000, Enterprise manager
that takes more than 30 secs to return, I get an 'ODBC SQL Driver Timeout
expired'. I have tried resetting every...
|
by: Thomas Richards |
last post by:
Hi,
I have a table with about 70k rows. When I use open table --> return
all rows and then edit a field Enterprise Manager then says it has to
return the entire result set for the update to take...
|
by: steve |
last post by:
Hi,
When I copy tables in a database from one server to another using
enterprise manager, everything copies ok, except for field defaults.
Has anyone seen this, and what is the solution?
--...
|
by: John Morgan |
last post by:
I have Enterprise Manager on my local machine. For the last twelve
months it has been connecting without problem to my online SQL Server
database provided by my ISP.
Three weeks ago the ISP...
|
by: drdeadpan |
last post by:
Hi,
I was using enterprise manager to generate a script for my DB. I
scripted only my tables and views and in Options I picked all the
options EXCEPT "script Primary Keys, Foreign Keys and...
|
by: Zorba.GR |
last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
|
by: Daniel Wetzler |
last post by:
Hi Sqlserver experts,
I use the SQL Server enterprise manager of MSSQL 2000 regularly.
I'm often annoyed by the automatic blanking of the table views.
If this happens then mostly with the hint...
|
by: chudson007 |
last post by:
Hi All,
What are the pros and cons between using Enterprise Manager or Query
Analyzer for my queries.
Currently I use Enterprise Manager because I prefer the interface and
only use Query...
|
by: Robert |
last post by:
I'm a newbie trying to find the SQL Server Enterprise Manager so I can
create a database. I have installed SQL Server 2005 Express and SQL Server
Management Studio Express. On the SQL Server menu...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |
