ApexSQL Edit

Non-Edit Development 4/12/05 - Design???

2005-04-12T14:38:00.000-05:00

Well, I'm in the process of putting some finishing touches on v2.16 before I release it this week (finally) and thought I would post an image of another product I'm in the process of working on. This new product I hope to make into a modeling tool specific to SQL Server with features to help the SQL Server Developer and DBA create and manage database models.

Notice how in the Orders table I have turned on additional viewing options so I can see the defaults, rules, check constraints, indexes, and permissions assigned to the table. My goal for the product is to provide a simple and powerful interface for managing/explorer schemas. For example, the product will provide 2 ways to create a new table, simple and detailed. Detailed will work much like other products. Simple will allow the user to simply enter the field names and the app will create the table using the data dictionary to determine types, sizes, nullability, and even FK constraints so that a complete table can be created quickly and accurately without having to specify the settings for every single column.

The product is still in early alpha stages but a lot of the drawing routines have been meshed out. Below is an image of the current schema view of the product. Still have a ways to go, but be on the lookout for this new product which I hope to have available sometime towards the release of SQL 2005.

Development 4/11/05 - Joins Be Gone

2005-04-11T09:38:00.000-05:00

I finally added a feature I have had on my personal want list for some time but never got around to it. While I was testing some SCC stuff this weekend and was waiting for it to finish I decided to spec out the feature and was able to get it into the upcoming v2.16 release.

For those of you who currently use the "standard" join syntax of "table join table on", you're life just got much easier. For those of you who still use the legacy join syntax (yes, that's what it's referred to and I do know some of you :), of "from table, table where table.col = table.col", you no longer have any excuse.

With v2.16, after you type "join", the Intellilist that is displayed will contain some new items when there are FK constraints that reference any table in the current query. Lookin at the Northwind database, if I type:

"select * from Orders inner join"

The list that is displayed now has some new entries at the top immediately following any schema:

- Join Customers (FK_Order_Customers)
- Join Employees (FK_Order_Employees)
- Join Order Details (FK_Order_Details_Order)
- Join Shippers (FK_Order_Shippers)

Notice that the options include both FKs that the current table has (Customer, Employee, Shipper) plus tables that reference the current table of Orders (Order Details). Picking any of these options will insert not only the specified table but the join condition as well (including any multi-col join conditions).

So, picking the - Join Customers ... option would then make my query look as follows:

select * from Ordeers inner join Customers on Customers.CustomerID = Orders.CustomerID

Do another inner join and you will get even more options, with the joins from Customer now included in the list. The joins are displayed from the most recent table to the least recent, so joins to Customer would be at the top and joins to Orders would be below these and so forth.

What about aliases, eh. Well, if you defined the table with an alias then the join condition will use that alias. Also, if you have predefined aliases for objects, then the join table and condition inserted will use those predefined aliases as well.

In my opinion, this is the best thing since the soup and sandwich combo at Panera Bread (I'm on my way there shortly :)

We will also be providing the ability to define custom joins in a future release so that the user can manually define join conditions that might exist outside of the normal foreign key relationships defined in the database.

The inserted tables will also follow the "Insert Object Owner" setting and insert the table schema for the new table if turned on.

Development 4/4 - Almost v2.16

2005-04-04T07:57:00.000-05:00

Well, we are almost done with the v2.16 release. We still have a few small items to finish development on dealing with some task issues as well as the new object mapping management screen, but we are hoping to release v2.16 very shortly.

This has been one of our longest releases, dealing with the complexities of supporting SCC and the amount of testing required to handle SCC as well as to make sure that Source Safe still works using the VSS API. We did add a new feature over the last couple of days to help make working with parameters a little easier. When the user hovers over a parameter/variable in the editor script, the editor will attempt to show the user the parameter/variable and its declared data type. If the item is a parameter and has an optional value, then that information should also be shown to the user as well.

After we release the v2.16 release, we hope to get back to having releases out every 5-6 weeks or so. We have backlogged a lot of new features we would like to add for the next release so stay tuned.

Thanks,

The ApexSQL Edit Team

Development 3/31 - Mapping Mgmt

2005-03-31T00:53:00.000-05:00

This is a screenshot of the new mapping mgmt screen which will allow mapping operations to be performed using drag and drop of files and objects onto each other.

This example shows a database on the left and some Source Controlled items on the right. You can see how the form shows the linkings between the various database objects and their corresponding Source Controlled items (in this case a Source Gear Vault system being accessed through SCC).

Development 3/17 - SCC

2005-03-17T09:39:00.000-05:00

Well, the SCC integration is almost complete and ready for testing by some users who have volunteered to test the SCC against a variety of systems.

My initial tests seem to show that it should work fairly well although with SCC being a somewhat limiting API, all of the features currently in Edit for SrcSafe will not be available with SCC. For example, the user will not be able to navigate the entire SC explorer as they can with SrcSafe but will be able to navigate at a project level. We are working to make it easy to switch between SCC projects and even have "saved" SCC projects so that the user can switch between them easily.

Some other differences will be in things like the history of files. Edit shows a custom history form where SCC shows the history form from the SCC system (if available and supported by a vendor's SCC implementation).

Once SCC is complete and out to testers we will begin on the object mapping mgmt screen and hope to have it complete sometime late next week. At that point we will begin wrapping up some items, adding any last minutes fixes and hopefully prepare for the release which should be the last week of March.

This has been the longest amount of time between releases, mainly due to the complexity of adding in the SCC integration. Future release should go back to 4-5 week range instead of the almost 7 weeks that this release has taken. In the future we may concentrate on getting out releases quicker with smaller number of items so possible 1-2 major enhancements and other smaller issues per release so that we can get changes out to the community quicker since this release has many items that would improve the current use by all users but is in a state where it cannot be released due to SCC and object mapping in a state of flux.

Development 3/9 - SCC

2005-03-09T23:37:00.000-05:00

Well, SCC integration is coming along. I've been able to check out, check in, undo check out, and add items in the schema mapping. I still have a ways to go like mapping a database, handling the source control explorer, etc. Hope to have all of those done over the weekend so that I can start getting some SCC users to test the basic functionality early next week. The process is going a little slower than I had hoped but it is coming along and working very nicely (at least with SourceGear Vault which is the SCC system I'm testing against).

I also finished the Task form and item mods so that when you open the task form now it will immediately search all open windows for tasks and then will thread off looking at procs, functions, and trigger texts in open databases. These will appear in the task window as they are found. Double clicking on a task that is in a database script will now open the script in a new window if the object is not mapped or open the mapped object if it is. I am thinking about looking at mapped object scripts as well for tasks.

I also added the functionality although still need the UI to do custom keywords in the editor. I have added 5 server/database types

UserTableToken
UserViewToken
UserProcedureToken
UserFunctionToken
UserDataTypeToken

and one universal type:

UserCustomToken

That can be modified so that items in these parsed cases will format as defined by the user, so the user can modify formatting color for these items in the editor.

By default, when connecting to a database, the editor will load the basic types for the five main types, so that by default the editor will use tables/views/etc. from the current connection and highlight them. The user can customize these per server/database using a list of specified tokens or a sql script that returns a resultset.

The UserCustomToken can be customized by entering a list of tokens.

This feature will make it so that tables/procedures/etc in the current script are highlighted differently than standard tokens which should make scripts easier to read and items easier to find.

Development 3/4 : SCC

2005-03-04T09:42:00.000-05:00

Well, I was finally able to hook a schema object to an SCC based Source Controlled item (in Source Gear Vault). I was able to successfully connect to the SCC system from Edit and also get latest and check out the file. I was not however able to check it back in since something is not wired correctly on that piece, but hey, who needs to check things in :)

Hopefully by early next week we should have the SCC functionality integrated and can begin full testing and possible involve others in the user community who use various SCC enabled systems since we are only testing using Source Gear Vault. We are currently working on opening pre-mapped objects so currently we have to add the mapping entry manually. For those that will be using the SCC object mapping, it will behave slightly different when specifying linkages between the database and SCC items since SCC does not allow the full tree navigation of all projects that Source Safe API does. This means that different "folders" or "projects" will maintain separate entries and may require a login when switching between projects. We are trying to minimize the logins required to the SCC system but some systems will require the SCC user to login more than others. This is not something related to Edit but related to SCC and the specific Source Control system.

We are looking forward to getting SCC out there for users to begin using and also the new object mapping interface to make the process of Database and Source Control integration easier and more powerful. Please continue to check the blog for additional information that we will be posting about the SCC integration.

Development 3/3 : Tasks

2005-03-03T13:42:00.000-05:00

For v2.16, I've modified the way Tasks work to make it more useful and provide more power in this feature. In addition to only having TODO tasks, you can now how TODO, BUG, and REMARK tasks. Additionally, you can create your own Task types and use them in the editor to markup your own specific tasks.

In addition to different types of tasks, you can now assign a user and status to a task and have that information displayed in the task view screen. So, the following task would identify itself for the user "Ashton" and having a status of "Open":

-- BUG{User:Ashton;Status:Open}: This item needs to be fixed.

Too much to type you say, well, you can now double click on the task item and a task edit form will display with the current task information and allow the user to edit it and have the task information change. Status and Task types can be selected from predefined lists. A status list is provided and can be modified to include other statuses.

All of this information becomes useful when you view the tasks using the Task viewer. On this form you can view all of the tasks for open files and then group by task type, user, status, etc. In addition, after the form opens, it will also look at any editor windows that have connections and look for task items in the text of system objects for these connections. These items will also appear in the task list and double clicking on these items will open the script from the database for the user to view/edit.

The improvements to tasks should make them more useful in managing tasks, bugs, etc in SQL scripts.

Development 3/1

2005-03-01T22:50:00.000-05:00

Well, I was able to implement custom tooltips when you hover over items in the editor. This should provide benefit to let users see info about a table/view/function/proc while in the editor. One of the nicer things I've found in testing is that, especially with table values functions, it will show not only the parameters, but the columns in the table that is returned.

Below is the tip from the Customers table, notice how it also incorporates MS_Description properties, if defined, for the table and columns:

Also, here is a function with a parameter and some columns:

I will probably add @parms for the v2.16 release. I may try to columns at a later date because to do columns properly, we'll have to do more parsing to try and determine ownership of the column.

If you have comments about what you see in this post, please post in the forums under BLOG:TOOLTIP so that others will know what the post is in reference to.

Also, in the shots, you might notice the new document tab list at top. This piece of the app was changed since the new control fixes the flicker when switching documents and provides the ability to re-arrange tabs as well as smart ctrl+tab tab switching.

Thanks

Development 2/25

2005-02-25T10:57:00.000-05:00

Just a short tidbit from work last night.

I finally switched Edit over to a different document tab control that seems to be much improved. It has the following improvements from the previous:

1. It looks better :) It has the same look and feel as the rest of the toolbar and menu items.
2. Allows for tab reordering. You can now drag tabs into different positions within the tab list.
3. No flicker when clicking. Now when you click a tab there will not be any of the current flicker where windows min/max or whatever it is that they do currently.
4. Intelligent Ctrl+Tab switching. Ctrl+Tab will now switch documents more like VS in that it Ctrl+Tab will go back to last document and not just cycle through documents. We try to see if this can be user customizable so that it can be turned off and have Ctrl+Tab work like in VS (which will be the default)

Kind of a minor change, but should reduce the current annoyance that is caused when you click on a tab to switch documents along with adding the additional features.

Using Edit - TODO: Items

2005-02-24T10:11:00.000-05:00

There is currently a feature in Edit that most people are unaware of (I'm sure it's my fault :)

In an Edit window type the following:

-- TODO: My first TODO item

Now, press Ctrl+F2. A task list window will appear and will list the TODO item that you just added to your file. If the file you added it to has a filename, then that filename will appear. If there is no filename, then it will indicate that. In () the line number of the TODO item will appear. You can jump to that line number in that file/window by double clicking on the TODO item in the list. The active window should switch to the current window and the cursor should be on the line number that was specifed for the TODO item.

The task list will currently display TODO items for any open query windows. We would like to expand this feature in several ways. We would like to give the task list the ability to look in the database itself and find any procs, functions, triggers that have TODO items listed in them and allow the user to double click on these and have them opened. If the item is object mapped then it would open the mapped file and not the database item instead so the user could work on the source controlled version.

We also thought about making the TODO line non-editable by users and having the TODO process managed by the app. This would allow the user to add more TODO info such as user, status, etc., and allow the user to change the status of TODO items, add additional info, assign to users, etc., such that when viewing the task list, users could view TODO items specific to them, of a specific status, etc.

Try out the TODO feature now and see if you think it is useful in its current state and if it would be useful with the changes listed above or if you have changes you think that would make it even more useful.

Please post forum topics under the subject "BLOG:TODO Tasks".

Thanks

Developer 2/24

2005-02-24T09:56:00.000-05:00

The last several days development had mainly been on small items such as small fixes and items posted by users. We have added the following new items so far this week:

1. Ability to script constraints
2. AutoReplacements that span multiple lines will now be inserted at current indentation level.
3. UDFs that return tables will now provide Intellisense for the columns, ie. select * from dbo.udfThatReturnsTable() f where f.[Column List should appear here]
4. Fixed some issues with the syntax generated when executing a sproc to make it include named parameters.
5. Included OUTPUT for out parms when they are inserted by intellisense
6. Added ability to have lists and data lists in SQL templates.
7. A content divider will now appear under "go" to provide visual separation of batches. (Default is ON, can be turned OFF)

Also fixed an issue where intellisense would replace what user typed with closest matched item, some other fixes as well.

We did change the visual display such that the document list now takes up the entire width of the app and works slightly different. Instead of the <> to loop through tabs, it now has a drop down when there are more tabs, much like what you get when there are more toolbar options to display. The reason for this move is to first of all to go with a single control suite for menuing and toolbars and also this new method fixes the problem that occurs currently when clicking on a toolbar item and having the windows do whatever it is they do where they go to normal size then re-maximize. This should make the windows flicker-less when switching by clicking on a doc tab.

We are also looking at possible providing tooltip items when a user hovers over text in the editor. So, when hovering over a table or column, a tooltip item will be presented that might contain some information. For a column, we thought about maybe having datatype (although datatype would most likely come from looking up column in database and not specific to the current context. Not sure how useful this would be since it could br wrong but would take too much time to parse and determine what table column came from, maybe).

Not sure what info would be helpful for stored procs or tables or functions. Maybe list of params, MS_Description property or something else? If you have ideas, please post them on the forums with the subject NEW FEATURE:Tooltips so other readers of the blog will see the post and we can attempt to keep all posts to this together.

I have also done some more testing with my SCC interface and it looks like it is about ready to be inserted. I plan to test some object mappings against an SCC system tonight using the interface. This will involve manually changing the object mapping file to include info specific to SCC integration. If this works we will go about fully integrating SCC into Edit. Once the integration is finished we will begin with the Object Mapping Mgmt screen to manage the object mapping process.

That's all for developmkent today, please post on the forums if you have questions or issues.

Thanks

Using Edit - Hide/Show Items in Explorer

2005-02-18T10:55:00.000-05:00

Using ApexSQL Edit, some of the things you can do to make your life less cluttered is to use the features of the application to hide information not relevant to what you are working on.

Edit provides several means to help clean up the clutter. One feature Edit provides is the ability to completely hide a database from the schema listing. How many of us have ever opened up model ot tempb to see what's in there. Basically these databases (and most likely master and msdb) just sit on the list of databases and take up room. Using Edit, you can right click on a database to bring up its context menu and pick the "Hide Database" option to remove the database from the listing. You can hide as many databases as you choose to. To make the hidden databases visible again you can right click on the server and choose the "Show All Databases" option.

Speaking of right clicking on the Server node, did you know you can print the schema treeview to printer. Simply right click on the server node and choose either print or print preview to view the treeview (as it currently appears now) and print it.

In addition to hiding databases, you can also add individual items within a database. There is not current UI to handle this, but you can add nodes to the Settings.xml file to have items excluded from the schema explorer.

The setting (you can have any number of excludes) takes a regular expression and will exclude anything that matches the RegEx value. For example, the following would exclude any object that started with sp_ (ie. system sprocs):

sp_\w*

Want to exclude those pesky dt_ tables:

dt_\w*

The items need to go in the Settings.xml file located in the main Edit directory underneath the Settings node, ie:

...

...
PLACE YOUR EXCLUDES HERE
...

The SchemaExcludes are a temporary feature until Edit can provide a full featured filtering system for displaying objects. The system we have planned will provide exclude and include plans with the ability to quickly switch between defined plans so you will be able to create filtering that includes all objects related to specific applications.

If you have a topic you would like to see explained in these Using Edit posts, please let us know through email or on the forums.

Thanks

Development 2/16

2005-02-16T17:27:00.000-05:00

Well, had a busy day on the forums today answering user suggestions, issues, questions. I did get a lot of items that should make it in v2.16 which will probably be available 2nd week or so of March.

While I am getting things in order to start on SCC integration next week, I have been working on adding a new Intellisense like feature that I'm calling Value Lists. How this will work is that it will take actual data based off of items provided automatically by Edit or customized by the user and will show data values in an intellisense type method to the user.

As an example, take the Customers table in Northwind. If the user were to type:

select * from customers where customerid =

At the point where the user types the "=", a list would appear will all of the items from the customer table such that it would show something like:

ALFKI - Alfred...
BEANC - ...
etc.

The user could then pick a value from the list or press the ESC key to cancel out of the list like normal.

How this would work would be that it would look at the column prior to the "=" and see that it is CustomerID, it would then look up CustomerID in a list similar to how it works for quick info and if the column was found (along with table/database/server/owner/schema matches) then it would display data from that table. This would also work if the user did the following query:

select * from orders where customerid =

Again, here the user would be shown a list of users for them to pick and insert into the script. The list itself could be turned on/off and the columns for which data values or displayed could be customized as well. This feature should really help when dealing with foreign keys or codes where you try to filter by some code or key that is not obvious or not well know. For example, you may not have a list for a Sex column, but a State column might have:

AK - Alaska
AL - Alabama
AR - Arkansas
AZ - Arizona
...

Another feature we are looking at for v2.16 is the ability to create project workspaces which can contain several types of items such as script files on disk as well as schema objects. The project would provide an easy way to deal with scripts and schema objects so that you could group items into a project metaphor and work on them that way. The project workspace could also have interchangeable connections such that you will be able to pick the connection for the workspace and have that connection applied to all queries. We are hoping that this will make it easier to manage projects that involve many script files but that also use schema objects.

For displaying the project workspace, I am thinking about displaying an additional schema tab with the workspace objects in place of the current server/database/object items. The workspace would then work similar to the current schema in that it would let users group things into folders, right click to open, etc. The list of items we want for project workspaces may be more exhaustive than what we can get into v2.16 but we hope to have an initial stab at it in the v2.16 release.

Release 2/12

2005-02-12T18:56:00.000-05:00

After a suggestion in the forums, we have changed how we calculate initial result grid sizes. The change should make viewing vertical results more useful. Below is a sample image from running sp_help 'sysobjects' and the resulting view of how results are spaced:

Release 2/10

2005-02-10T13:45:00.000-05:00

Well, I finally wrapped up the v2.15 release late last night and turned it over for placement on the web site. I wasn't able to get all the things I wanted in v2.15 such as server drop down, changes to statement log viewer, and object mapping but each had valid reasons to be moved to a future release.

Since we plan to begin including SCC support in Edit with the v2.16 release, the Object Mapping piece just made since to move to that release since it will have to integrate with SCC as well so there was no need designing something for v2.15 and then redesigning it for v2.16. The server drop down and statement log viewer items also got nixed for this release because of implementation issues. They should make it into v2.16.

I am happy with what made it into this new release. Around 10 or so issues were fixed, with a couple of them generating the majority of the exception reports I receive. Maybe now my email want fill up as quick :) This release also finally adds vertical results so that multiple result sets (including XML results) can be displayed in a single tab vertically instead of multiple horizontal tabs. I was also able to get rid of using the HTML browser control for XML result sets and use the editor control after getting XML outlining and syntax highlighting to work like I want.

Also added some nice new items to Quick Info that make it more useable. Added the ability to have multiple queries for a single column and also to allow additional data from the resultset to be used in the query. The quick info window can now also stay open even when the user clicks back in the editor, allowing a "tidbit" of info to remain visible.

Also added a new Alias feature to let users pre-define aliases for tables so that the user can use the alias in the select clause to bring up column list before defining the table. There is even a setting to have the alias auto-inserted when the user picks the table from a drop down list.

Some smaller features were also added such as the ability to see release notes, ApexSQL forums, and newsgroups in the editor directly, auto fit of result columns, additional features on object search screen, advanced grid copying in the result grid, as well as the ability to easily copy a range of cells to the clipboard. You can now click in a cell, hold down the shift button and click in a different cell, and the range of values with be copied to the clipboard in Excel format (tabs between columns, CRLF between rows). This should make it easier to copy ranges of values from the grid to other programs.

Most of the new items were added based off of user requests on the forums so please continue to post new items on the forums as well as report any issues. For v2.16 some of the features I want to add include SCC, Object Mapping, Projects (ability to create projects with script files, results, etc and open them all up so that a project can be worked on easily), a TODO UI screen (type -- TODO: Some text on a line and then press Ctrl+F2 to see TODO now), expand TODO to look in database objects that are not currently open, table editing feature to let user edit table columns, drop object ability, permission viewer/modified, and other small fixes.

All of the above may not make it into the next version, but the primary focus will be on SCC, Object Mapping, and then table editing, projects, and TODO.

Thanks and keep "Edit"-ing - Ashton

Development 2/8

2005-02-08T10:08:00.000-05:00

Continuing to work on v2.15 in an attempt to get it release this week. Fixed several additional bugs dealing with various issues. Also modified the Ctrl+Space intellilist prompts in some instances to provide more context information. If the cursor is at the end of a @ or @@ parameter and the user presses Ctrl+Space, then the list will contain appropriate parameter values.

Also, if the user presses Ctrl+Tab while in the insert () column listing, the user will receive the column list for the table and when the user is in the context of {table}.{col} and the user brings up the intellilist, it should display relevant column information.

We also added the ability to select a range of rows/cols in the grid and have the results copied to the clipboard. When the user selects a cell in the results grid using the mouse, if the user then holds down the SHIFT key and selects another cell, then range of cells will be copied to the clipboard, with the information bounded by the top-left most cell and bottom-right most cell.

We currently have 3 more bugs, 2 issues, and 1 enhancment left before we are ready to release this version. Please check the forums or this blog for additional information.

Thanks,

The Edit Team

Development 2/1

2005-02-01T09:08:00.000-05:00

I added a new feature to Edit that may provide some additional benefit to users. A new tab was added to the options dialog that allows the user to specify aliases for objects, specifically tables and views. These aliases will be used in the editor whenever the user tries to bring up a column list for an alias that has not been defined yet.

For example, if the alias cust is defined for the table customers, then when typing the select clause, the user can use the cust alias and still get column info before defining the from clause so that the alias can provide column information before the user has defined it so that the select clause can provide Intellisense without forcing the user to define the from clause first. The aliases can be defined from very specific (assigned to server/database) to very general (any server/any database). When Intellisense has an alias that it cannot resolve in the current context, it will look in the aliases definitions from the most specific to the least specific for a matching object and then attempt to show Intellisense columns for that alias.

We are also "thinking" about providing an optional switch that would let the user have the table/view Intellisense automatically insert the defined alias when the user picks a table/view from the list. The system would do a reverse alias lookup and find the object and then insert the alias for the user. This would help a user keep tables aliased in the same way once defined.

Development 1/30

2005-01-30T22:59:00.000-05:00

I did finally finish the issues I was having with the vertical results screen. It should now work correctly and will allow the user to view results vertically like Query Analyzer instead of the current horizontal display. Also, unlike QA, if any queries are for xml queries, then they will display in a text edit box with outlining and color coding that would be expected for XML documents.

I also entirely redid most of how Quick Info works. Everything will still work the same, but there are now new features where a user can create multiple quick info queries for the same column and when the user goes to get quick info, they can choose from the quick info query that they want to run. The user can also now access other values in the row so that queries can be run against not only the value that was clicked but any values in the result row. The quick info window can now also be set to stay open until the user explicitly closes it, thereby allowing the user to see quick info data while performing other actions. All of these features should help users find and research data better.

I also fixed some isses specific to databases specified with [], the Columns node showing columns repeatedly, adding a comment when adding file to SrcSafe, etc. Still on track to work on object mapping this week in addition to finishing some other items like improve object search, adding server drop down on toolbar and some other items. Working hard to finish these items up so that we can begin adding SCC functionality to allow non SrcSafe systems to use Edit Object Mapping.

Development 1/26

2005-01-26T13:23:00.000-05:00

I was able to resolve some of the issues with the vertical results, specifically switching to text results (and back to grid) will now not lose the control. A couple more issues to resolve in vertical results and then I will begin fixing a couple of other small items such as some issues that were brought up in forums, the changes to the object search page, the new pre-Alias page and some minor performance improvements.

The goal for this week is to resolve or finish all outstanding issues to go into the next release with the exception of the Object Mapping mgmt screen which we will concentrate entirely on next week.

Development 1/25

2005-01-25T10:32:00.000-05:00

Well, I've almost finished a feature that users have been wanting for some time. The ability to have results displayed vertically in a tab instead of across multiple tabs. There are now 2 toolbar buttons that let the user switch from horizontal to vertical results for retrieving results.

When getting vertical results, the controls are displayed in a single tab similar to how Query Analyzer handles results. Still have to handle some things like printing results and switching to text results, etc, but the basic functionality is there now with the new XML result viewer as well.

Also added a couple of user requests to the Object Search page. Added the ability to change the server (although haven't fully tested it yet) as well as the ability to print the object search results and add an object from the results to the favorites for the database. I hope to also implement custom menus and actions in object search and possibly allow searches across multiple databases. May not make v2.15 but will see.

Also started work on what I refer to as pre-Alias screen that will allow the user to specify global or database aliases for tables so that when typing in a select clause where the from table has not been defined, if the user uses a predefined alias associated with a table then the columns will appear. Allows user to type select statement and get column intellisense without having to first define tables in from clause.

Also, I think I finished work on the typing Intellisense with the addition of the delay and min char length on the options dialog to allow the user to specify the delay before the list comes up and the number of characters required in a token before the list will be displayed. Seems to work fairly well but might could use a couple of small improvements.

Once I finish up the object search features, the vertical results, and the pre-Alias stuff I plan to work on the Object Mapping Mgmt screen and then work on getting any fixes in for a release, so hopefully sometime in the 2nd week of February we'll see this release and then we'll begin integrating SCC into Edit to allow non-SourceSafe systems to use Edit and Source Control integration.

Development 1/22

2005-01-22T22:27:00.000-05:00

Continued work on some SCC stuff and think I've finished the main interface to allow the editor to perform SCC actions. Still have to hook it into the current Edit infrastructure but tested most parts of the SCC interface and it seems to work fairly well.

Also added a new Intellisense feature where intellilists will be displayed automatically (option to turn off, defaults to on) as the user types after a user defined delay that will display context information. So, if the user were to type:

se

The editor will display

session_user
select
serializable
setuser
set

And any schema objects that begin with "se".

This should provide some benefit when typing where the beginning of an item is known and after a user defined delay, the information will be displayed in a list that can be selected.

Development 1/20

2005-01-20T22:16:00.000-05:00

Well, I finally started doing some work on the SCC interface. Currently coding the objects to fit into the interface model that Edit currently uses. Work seems to be going fairly well. Was able to get most of the higher level objects created for actually getting items and projects and also the UndoCheckOut and CheckOut items coded and unit tested.

The big test will come when we try to integrate the component and actually let the user assign SCC items to schema items since the interface is very different, ie. you can only see one SCC project at a time. However, we may store projects that the user has used in the past and allow these to be treated as sibling folders to provide some manner of easier access, but the user will still have to go through the standard SCC interface when mapping to a new project. I'll keep the blog posted with the progress.

Development 1/19/05

2005-01-19T17:25:00.000-05:00

Well, I'm finally working on creating a new way of handling the Database<->SourceControl mapping. I've decided to try and create a treeview mapping concept that will show database objects on one side, source control projects and items on the other and then show the mapping as lines, similar to the way DTS shows transformation items.

In addition, the user will be able to drag items to perform mapping between them, drag folders onto projects to perform "best fit" matching for an entire schema, see which items are missing mappings, etc.

The form will also have the ability to create objects in the database that exist in Source Control but not in the database as well as vice versa. Hopefully all mapping can be easily managed from this page.

Below is an image of the test form with a concept of my idea:

Development 1/18/05

2005-01-18T13:52:00.000-05:00

Well, using profiling tools I was able to find a fairly major issue in how we were handling outlining in ApexSQL Edit. We were basically looping through all outlining regions looking to see if the current token would be the end of the statement. However, we were not checking to see if the token fell within the range of the outlining section so we ended up checking every section and doing a recursive check even when it was impossible for a token to be within an outlining block. I fixed that code so that outlining in Edit should now be significantly quicker, especially when opening large files with outlining turned on.

Also continued to look for other improvements that can be made to performance issues and also continued to look at making results display vertically in grids in the same tab, similar to how QA does it. Having an issue with splitters working correctly, the IE web browser control loading items properly when displaying "for xml" queries, and getting items to show on the first execution. I hope to have this in for v2.15 but may either delay v2.15 to maybe 2nd week of Feb or drop some additional items I had planned to make sure this item gets into next build since so many people have asked for it.

Probably won't be doing much more development tonight since I am giving the presentation at the local .NET User Group tonight (www.ptnug.org).