Jun 19, 2008

Features for next version

Version 3.23 is realized and all known issues seem to be fixed. Now we will take some time and work on improving existing features. One of the main feature which will be looked at is Intellisense. Currently it's fast and useful but limited in certain situations. One of the issue is Intellisense implemented as one peace of code which handles it for all different databases and it became pretty messy. Sybase and Microsoft SQL Server are very different from Oracle and DB2 so the plan is to separate code for different servers which should make it simplier and easier to extend.
One of the distinctive features of SqlDbx is how fast it compare to other tools. There's always ways to improve it. Will try couple of things in this area. Also it's time to improve help file.

13 comments:

fabricioaraujo_rj said...

Including the right indentation operation (the inverse operation of Shift+Tab keystroke) would be real nice.

Anonymous said...

A feature that would be useful is to be able to right click on a temp table to display the contents in the results pane. it wouldn't have to script the sql in the editor window, just put it in the results pane. It would also be useful to be able to drop all temp tables.

SqlDbx said...

You can right click on temp table and first menu item will be drop temp table. Being able to show content of temp table by right clicking on a table name sounds like not a bad idea

Anonymous said...

For Sybase ASE 15 adding User Defined Functions at the left pane like procedures, views, triggers, tables will be a good feature.

SqlDbx said...

Support for Sybase SQL User defined functions will be included in the next release

fongus said...

hello I want to show you a bug in SQLDBX
on a sybase server when you want to display a stored procedure with sp_helptext that does'nt take in the screen the Carriage return and obviously the stored procedure is illegible.
is there a solution to correct that ???

SqlDbx said...

Can you email description of this issue and if possible screenshots showing this problem to suppport@sqldbx.com

Anonymous said...

I see the feature added to select * from a table you right click on (version 3.25). I have two sybase servers (same version) that I connect to. On one of them it works.

When I right click on a table the option to select * comes up. When I right click on a temp table the option of select * and drop table comes up.

On the other server it works for select * for tables but I don't even have the option to drop temp table anymore when I right click temp tables.

Do you know what might cause this?

SqlDbx said...

This is the query we use to retrieve information about temp table.
SELECT name from tempdb..syscolumns WHERE id = object_id('tempdb..#table_name') ORDER BY colid.
Does it return anything when you run
on second server?

Anonymous said...

--Select * from temp table --
In the server it is not working for I have more than one tempdb. When I find out which tempdb the connection is using and substitute that for tempdb in the query then it returns the columns for the temp table. Thanks for your help.

Anonymous said...

I spend a lot of time (probably like many others) debugging stored procedures. I have never seen a tool that truly allowed you to debug with the ease that other developer tools allow. Have you ever condidered creating a pseudo-debug environment? Seems feasible that you could track variables as they are declared and values as set or selected and behind the scenes reissue these statements as you "step through" a stored procedure. This "mode" would obviously be issuing a lot of extra statements, but the value for debugging would be immense. With the newly added "select * and drop " temp table features you would have the equivalents of watches at your mouse-tip... Just a thought. So far I a pretty impressed. Right balance of features and ease of use. Add debugging and I bet you would win over a lot of folks! Microsoft's attempt to bring DB developers into Vis Studio missed the mark in my opinion so the market is probably still out there...

Anonymous said...

PS to previous post:
If you did add debugging, since you will be tracking variable values, you could probably add the ability to define watches on temp tables and variable and literally return results of temp table selects and variable set/selects to results tabs or a new variable watch window. I know it's an ambitious suggestion, but no one else has features to match!

SqlDbx said...

That's an interesting idea. Will have to sleep on it. I agree with you that somehow SQL debuggers which mostly look and feel like C++ debuggers do not feel natural for SQL. It's not trivial to do but may be something can be done.