Extending the Sedna Data Explorer - Teaser Posted

In an effort to entice you to sit in on my Extending the Sedna Data Explorer session I have recorded a short teaser video, and have it posted on the Southwest Fox Video page. The same session will be given at the German DevCon in November.

Please take a look and let me know what you think.

Does Sedna require VFP 9 SP2?

Over on ProFox there has been some minor grumbling about Sedna requiring SP2. I do not think SP2 is required. I can see some of the components requiring VFP 9, but my guess is the components will work fine with SP1 and maybe even the RTM version.

I think the only things required is the .NET 2.0 framework for the NET4COM, Visual Studio for DDEX, SQL Server for the Upsizing Wizard, and Vista for the VistaDialogs. I believe the SP2 requirement on the Web site is one of those things where Microsoft puts the latest version up because it is what they support.

If you think about it, Microsoft did not enhance the core VFP 9 EXE other than to fix bugs (and put some new ones in {g}). Even the new Reporting enhancements in SP2 work in SP1 (something I heard from Colin Nichols at OzFox 2007 if I remember correctly).

The one thing I have not tested is attempting the Sedna install on a machine without SP2. I would be very surprised if the installer checked to see if you have SP2 installed first. If we find out this is the case, I have a workaround to have both SP1 and SP2 on the same machine peacefully.

Sedna Released!

I know this has been long in coming, but very early this morning (1:00am EST) Microsoft released the much anticipated Sedna add-ons for Visual FoxPro 9.

You can download it from the Microsoft download site. There is a readme file and an MSI file to download.

Sedna includes the DataExplorer updates, DDEX for .NET access to VFP data, the MY IntelliSense extensions, the NET4COM examples to bridge VFP and .NET, the Upsizing Wizard for SQL Server, and VistaDialogs4COM to modernize VFP on Vista.

I will be installing it soon and will post my thoughts a little later.

Sedna DataExplorer Tips

If you want the new Sedna DataExplorer to be the DataExplorer showing up in the Task Pane Manager you need to copy it from the Sedna Beta folder location to the VFP 9 root folder. You might want to rename the existing one before doing this in case you want the old one for some reason. For some reason I expected Microsoft to include the new DataExplorer in place of the old one, but the Sedna beta installs itself below the VFP root folder.

If you are tired of typing in a long path to run the DataExplorer in standalone mode you can do a couple of things to save you time:

1) Once you copy the DataExplorer.APP to the VFP 9 root folder you can type DX in the command window to run it in standalone mode.

2) You can edit the DX entry in FoxCode to run the DataExplorer.APP in the Sedna beta folder. To edit the script you need to bring up the IntelliSense Manager, go to the Custom page, find the DX entry and click on the Script button.



3) Type in the Command Window one of the two:
DO HOME() + "DataExplorer.app"
DO HOME() + "Sedna Beta\DataExplorer\DataExplorer.app"

Hopefully you are all testing the new Sedna extensions and VFP 9 SP2.

DataExplorer - CTP 4

I see in the CTP 4 (February 2007) readme file the list of things added and fixed to the Sedna Data Explorer is incomplete. Here is the list of changes made just for this release:

Bug Fixes:

• None in this release (waiting for the Fox Community to provide feedback)

Enhancements:

• Return from Options dialog no longer collapses the treeview. (ER in CTP 3 Preview)
• Menu Manager Dialog, Add-in Manager, Drop and Drag Manager - Double-click on the menu list brings forward the Script to Run page, and right-clicking on script editboxes will bring up script in program editor.
• VFP Database Documenter - Has HTML option. HTML controlled by CSS in template (user maintainable)
• Refresh button added to the main form just like Visual Studio Server Explorer
• Icons now available on the main form buttons. Icons are compatible with VS .NET Server Explorer where appropriate.
• Main form buttons now have user selectable properties on Option Dialog (show or hide icons, and separately set the Hot Tracking style).
• Run Query dialog now runs selected text if user has selected text, otherwise runs entire query
• Run Query dialog now displays query error message in the Messages tab, previously nothing happened if problem with query.
• BROWSE form now adds records when Ctrl+Y keystrokes pressed for VFP data sources.
• Exposed the location and file name of the Data Explorer metadata on the Options dialog so user knows where it is located.

IMPORTANT: To test the add-in enhancements you have go into the Data Explorer Options and press the Restore to Default button. I recommend you keep any connections you have and any third-party options added. This will load the new features into your DataExplorer.DBF metadata file where your connections are, as well as the add-ins, menus, and drag/drop functionality.

If you are interested in the list for CTP 3 (October 2006) you can check it out here.

Enjoy!

Sedna Data Explorer

I have been meaning to blog about the Sedna Data Explorer for a long time. Mostly to inform developers reviewing the October Community Technology Preview (CTP) of things they can test so the bugs are revealed sooner than later.

In case you have not attended any of my Data Explorer sessions over the last few months or the Southwest Fox 2006 Keynote, I have been working as a contractor for Microsoft on the changes for the Sedna update to the Data Explorer. It has been a real pleasure to work on this developer tool. I have developed a real respect for the work Ryan Katri (Code References, Evironment Manager, Toolbox, and Task Pane are the other tools he is famous for) and Randy Brown (retired Product Manager) did on the original version. The design of the Data Explorer is very well done and the code is written well too. I wish there were a few more comments in the code, but figuring out how it works was straightforward. I have also learned numerous techniques to incorporate in my own developer tools along the way.

As you might know, I have been a little vocal about some of the bugs in the original Data Explorer release so Microsoft asked me to put up and fix the bugs, and include numerous enhancements in the Sedna version. I gladly accepted the challenge.

The first release for public consumption is in the October 2006 Sedna CTP and VFP 9.0 SP2 CTP. Please note this is not a production release as I wrote about here. You need to carefully load this over on a test machine or in a test folder. Steps to do this are in my blog entry just mentioned. Note: The Sedna CTP is separate from the SP2 CTP. The Sedna CTP does not overwrite any critical files. In fact, the entire release is installed in a separate folder under your VFP 9 root folder. There are few risks to installing and running the Sedna CTP.

There are however a couple of things to consider with respect to the Data Explorer. First, if you use the Data Explorer pane in the Task Pane Manager you will not see the new version. The Task Pane Manager looks for the DataExplorer.APP file in the VFP 9 folder. If you want to use the Sedna version you need to rename the original version to something else, and copy the Sedna version from the "Sedna October CTP" folder to the VFP 9 folder. If you want you can just run it directly from the Command Window:

DO HOME()+"\Sedna October CTP\DataExplorer\DataExplorer.APP"

The second item on the check list is the shortcut menu for the tree view is where most of the Data Explorer functionality is found. Several new features have been added in the Sedna release. These features do not automatically show up on the menu if you have been using the Data Explorer previously. The reason is the functionality for the shortcut menu is stored in the metadata: DataExplorer.DBF in the HOME(7) folder. The new functionality is stored inside the DataExplorer.APP file internally in a DBF file. If you want the new menu functionality and want to retain your existing connections and extensions you have added or downloaded you need to update your DataExplorer.DBF metadata. This is accomplished via the Options dialog. First click on the Options button on the Data Explorer toolbar. On the Options dialog you will find a button called Restore to Default. This might sound like you will be set back to the factory settings, and indeed this is possible, but you can also retain the connection settings and your extensions you have added.

Click on the Restore to Default button to start the update process. You will be prompted with a message: Do you want to maintain connections and customizations that were done by you or a third-party vendor?” Click yes if you want to save your changes and get the new enhancements. Click no if you really want to be reset to factory settings including and include the new functionality distributed by Microsoft in the Sedna release. One note, if you made any enhancements to the native code included in the original Data Explorer features, it is likely the Data Explorer will reset it.

For instance, I have changed the behavior of the Design option for VFP tables and views to run the White Light Computing ViewEditor instead of the native View Designer. Each time I restore the native functionality I select the option to save my connections and additions. It does that, but restores the original code for the Design feature and I need to reset the code to work the way I want it to.

My recommendation to you is to create a backup of the DataExplorer.DBF file using the Options dialog before restoring the functionality. This way you can get your customized code for the native features and restore the code overwritten during this process.

There are no compatibility issues with the DataExplorer.DBF and nothing gets structurally changed. You can still use the original Data Explorer once you work with the Sedna version. I have not run into any issues doing so. Things do work differently between the two, and hopefully the changes are for the better.

The changes discussed in this blog post are based on the version shipped in the Sedna October 2006 Community Tech Preview (CTP). It is important to note at the time this post is written the features to be included in the final release have not been finalized.

The list of fixes/enhancements in the Sedna Data Explorer are a bit longer than the Microsoft list included in the Sedna CTP release notes.

Bug Fixes:

• Drag/drop of VFP table/view from the Data Explorer to a form now sets the grid's RecordSource.
• Drag and drop operations now respect Field Mapping settings for SQL Server data
• Fixed drag and drop of VFP table from Data Explorer to a form when a Field Mapping setting is set to a non-existing class or class library. This triggers a C5 error every time. Now you get a message telling you to fix the Field Mapping.
• Default values are displayed in the description pane for VFP data. Previously you see nothing or a logical false (.F.) even for non-logical data.
• Run Query dialog - running add-ins while on the Message tab triggers an "Alias Not Found" error.
• Run Query dialog - result set grid with General fields, double-click on general field triggers "Field must be a Memo field" error.
• Browse form - change auto incrementing integer column causes the grid to lose the RecordSource, and thus causes the grid to lose all the columns.
• Included David Fung's fix for stored procedure sorting when using the Korean code page.
• The issue with free tables not showing their columns when expanding the node was an issue I introduced in an interim build to Microsoft. You should not see this in the original version or the Sedna version.

Enhancements:

• Ability to sort objects (tables, views, stored procedures) is separate from the ability to sort columns. See connection properties for new setting.
• Display SQL Showplan for local views via context menu.
• Display Database Documention for VFP databases via context menu. This is text output in the October CTP. I have a newer version of this I demoed at Southwest Fox that outputs to HTML, has CSS control of the output, and does a better job documenting the database.
• Launches the new and improved Upsizing Wizard for VFP database connections via context menu.
• Options dialog has Rushmore Optimization Level setting for the showplan features now included in the Data Explorer. You can set this to your favorite setting once and the options will display the results using this setting.
• Options dialog allows you to pick where the Upsizing Wizard is located. This allows you to run the one that ships from Microsoft, or your own enhanced version, or possibly one you get from an open source project like VFPx in the future.
• Option dialog has a new button to back up the DataExplorer.DBF metadata file. This was a personal requirement because I was tired of hunting the file down during my development of the new feature for the Sedna version. I need to back up my source often.
• Run Query dialog has "(F5)" added to the Run button to expose previous functionality of using the hotkey to run the query (the same hotkey as SQL Server Query Analyzer).
• Run Query dialog has Report result add-ins to generate reports in form and columnar style.
• Run Query dialog Message tab on the result set now shows the Rushmore Optimization level and number of rows returned for VFP data. SQL Server queries always showed the number of rows returned.

I have made several new enhancements since the CTP release which I will blog about when I know they are going to make it into a future release. This has been a fun project and I look forward to hearing the feedback you provide to Microsoft.