NuSphere Forums Forum Index
NuSphere Forums
Reply to topic
DB Client (mssql backend)


Joined: 27 Mar 2006
Posts: 77
Reply with quote
I like the db client it is great!.

When you double click on an object it gets its specific details by default.

Most of the time I am just debugging a syntax error in my sql and have to wait (slow connection not a fault of PHPED) for the db to respond just to get the the sql editor. Is there a way to jump straight to the sql editor and bypass the db object details.

Also there is a slight bug in the db client.
If I expand to one of the databases and view its details then double click on the databases link (first option after expanding the db server) when it tries to load the status tab I get a "Invalid object name syscurconfig". If I try processes or System they both announce similar errors.

If I go to the master table then to the databases link it works fine.

I am assuming it is caching the most recent database name instead of defaulting to master for the databases link.

TW
View user's profileFind all posts by twSend private message
Site Admin

Joined: 13 Jul 2003
Posts: 8344
Reply with quote
What database do you run?
Does the problem happen on the system (or default) scheme, or it happens on yours?
View user's profileFind all posts by dmitriSend private messageVisit poster's website


Joined: 27 Mar 2006
Posts: 77
Reply with quote


In the above image it would be the one labeled Databases.

If you were to double click tempdb then double click databases you get this problem.
Then if you double click on master then databases it works fine.

If you are not aware master is the location of the tables that are queried when databases defaults are loaded.

TW
View user's profileFind all posts by twSend private message
Site Admin

Joined: 13 Jul 2003
Posts: 8344
Reply with quote
I'm not sure I got what you mean.

Please submit screeshot of the IDE when you get the problem.

TIA,
Dmitri.
View user's profileFind all posts by dmitriSend private messageVisit poster's website


Joined: 27 Mar 2006
Posts: 77
Reply with quote
step 1: Open Databases.

Step 2: Open tempdb.

Step 3: Open Databases again.

If we return to step 2 and select master and the do step 3 again it will be fine.
View user's profileFind all posts by twSend private message
DB Client (mssql backend)
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 5 Hours  
Page 1 of 1  

  
  
 Reply to topic