Archive

Archive for the ‘Uncategorized’ Category

Oct
13
(this is a sort of warmed over blog post from VFP 9 SP1 Installation Tip posted back on September 24th 2005)

Please note, there has been some confusion in the community about the VFP 9 SP2 release announced by Microsoft this week. It is a Community Technology Preview (CTP), which is another way of saying pre-release, alpha testing. Do not load this over your production copy of VFP 9 SP1 (or no service pack) without reading this post and understanding the advice it offers.

Before you install this service pack, back up your original files in case you need to go back to the original version. This tip also allows you to run both the release version of SP1 (build 3504) or the original release of VFP9 (build 2412), and the beta of SP2 on the same computer. I have done this for the service pack testing of VFP 7, VFP 8, and VFP 9 and it worked well. Here is what I do before installing:

  1. Go to the following folder: C:\Program Files\Common Files\Microsoft Shared\VFP
  2. Create a subfolder called VFP9SP1
  3. Copy all the VFP9 Runtime files including VFP9r.dll, VFP9t.dll, VFP9rXXX.dll (resource files, especially the ones you deploy), the three Report*.app files, the FoxHHelp9.exe, and the FoxHHelpPs9.dll to this new subfolder.
  4. Go to the following folder: C:\Program Files\Common Files\Merge Modules
  5. Create a subfolder called VFP9SP1
  6. Copy all the VFP 9 merge modules to the new subfolder
  7. Copy the main VFP 9 folder to another folder. I call mine: C:\Program Files\Microsoft Visual FoxPro 9 SP1

You have to worry about those three folders.

Craig Boyd and Bo Durban have also heading into the waters and provided some sage advise on the SP2 install.

If you want to be extra careful you can also export the registry settings for VFP 9. I have not done this in the past and have not had any problems skipping this precaution. You also might want to back up your FoxUser files and the HOME(7) folder where files for the Data Explorer, Environment Manager, ObjectBrowser, Task List, Task Pane, and Toolbox save their metadata.

Now you have backups of the VFP 9 SP1 files and it is safe to install both the Sedna and VFP 9 SP2 files.

I take these precautions for two reasons. The first is so I can double check things in the released version to see if something works differently with the second SP installed. I can verify bugs which are suppose to be fixed, and validate problems found in SP2 to see if they are newly broken since the released version.

The second and more important reason is I might have to release new versions of my current VFP 9 apps and I do not want to do this with the beta runtimes. I can build the apps using the VFP9.exe in the SP2 folder. Before doing so I swap in the VFP 9 runtimes and merge modules. If I need to do this I create subfolders with the corresponding SP2 files just like I did with the original files. After I am satisfied with the testing I build my installs with the released version files. Once I ship the product I swap in the SP2 files and proceed with the testing.

I install the SP2 beta over the original folder (C:\Program Files\Microsoft Visual FoxPro 9). Note, this will automatically overwrite the merge modules and runtime files too. I create two shortcuts to VFP 9. One for the SP2 folder and one for the SP1 folder. I use the appropriate shortcut for the type of work I am doing, but I can tell you I use the beta version for most of the time. The Fox Team has been very good about shipping stable betas over the last few years.

This is the first of hopefully many releases between today and the time Microsoft ships VFP 9 SP2. This is also very early in the testing cycle, so your results can be interesting. Especially when Microsoft has not posted the changes in the Service Pack (hopefully an oversight soon to be corrected).

Happy testing! I will watch for feedback on the release, especially where the Data Explorer is involved {g}.

Oct
01

This morning I received some great news from Microsoft that I have been named an MVP for the 2006-2007 season (renewed on October 1st each year). This is the sixth consecutive time I have been honored with this award.

The MVP award is the way Microsoft recognizes individuals for their contribution in supporting Visual FoxPro developers by answering questions on forums, presenting sessions at conferences, and writing articles, blogs and books. More information about the MVP program can be found at the MVP site.

This is an absolutely an honor. It is my intention to continue helping other VFP developers on FoxForum.com, the MSDN forum, other forums, at conferences, through this blog, and via some articles I am putting together.

Oct
01

I am pleased to announce the official release of White Light Computing’s ViewEditor Professional v3.6 Service Pack 1! This release is free for registered developers.

List of the new/updated features in this release:

  • Include comments in view script (like the date/time it was generated and the view Comment property).
  • Added more documentation on setting up macro substitution view parameters with VFP 9 based on feedback from developers in the “Macro expansion and view clauses topic” in this Help file.

Bug Fixes:

  • The Inherit Table Properties feature triggered the error message “Not a character expression” when running the ViewEditor from the Stonefield Database Toolkit.
  • The Inherit Table Properties feature stopped inheriting field properties if one field has a bad UpdateName.
  • The Copy View Code feature was missing the Comment property for fields (it has been in the view properties).
  • The Copy View Code feature was using brackets for quoting character strings on DBSETPROP() values. This was a problem if you had bracketed strings for view and field properties such as Caption, RuleText, etc. The code now has brackets ([]) if you have single or double quotes, and double quotes if you have brackets in the strings. Single quotes are used if there are no brackets or single quotes in the string. If you are mixing and matching you may get unexpected results in the code.
  • Cleaned up view code with respect to DBSETPROP() in the generated code.

The current ViewEditor Help file is available for you to review if you want to learn more about this popular tool.

Sep
30

I believe you have all experienced a client who asks for the impossible, but despite all odds you some how pull it off. You produced what I call the “IT Miracle”.

Depending on your perspective and beliefs, a miracle can have many meanings. So for the sake of this discussion I propose the meaning to be this:

1. an effect or extraordinary event in the software development world that surpasses all known human or natural powers and is ascribed to a supernatural cause.

An IT Miracle is simple. The user asks for something you figure can only be accomplished by using a time machine, a magic wand, pixie dust, telepathic communications, more money than the customer has, and a truckload of Staples Easy buttons.

Not only do they ask the impossible, they put up several roadblocks, leave out critical details, respond slowly to questions, accelerate deadlines, and maybe toss in a few extra last minute requirements they got to have or the project will not be deemed a success.

Some of these impossible tasks are driven by business needs, some are necessary to provide competitive advantages, some of them are wild and crazy ideas by pointy-haired-bosses, some are in response to project disasters, some are necessitated to help users who are desperate for help, some are driven by governmental legislation, and the list goes on…

Add in the dependency of others pulling their weight on the project. Maybe it is counting on a project manager to handle all the critical paths, solid specs from the business analysts, developers providing good estimates and finishing up their components on time, DBAs making the data changes on time, testers building the proper and efficient test plans, users performing acceptance testing, tech support folks coming up to speed on all the changes, hardware being delivered on time and in some cases designed/developed/built. Maybe you are in charge of all these aspects, which may or may not be better than having others help you.

Clear communications is always one of the biggest stumbling blocks. Forget one little communication and the whole house of cards can come tumbling down.

Quite frankly, I am amazed the simplest of projects come together. Maybe every project is an IT Miracle.

I just finished working on my latest IT Miracle project. It really was not a whole lot of fun. Usually they are fun. Five conversions from four different database schemas to one common database in three months. This means five different customized conversion source code bases (even the data in the common database schemas were different enough from each other). Lots of code had to be written and had to be perfect to ensure no data was lost. Three of the conversions were from databases we had no prior contact. The last time we did one of these from scratch it took four man months and we were asked to do all five in three months. I told the customer it was going to take an IT Miracle. The client was not open even slightly to any deviation to completing this before September 30th.

The last conversion happened last night despite the odds. Only because key players on the team did what ever was necessary to get the job done. This is the key. Find people who are dedicated to pulling off the impossible and be flexible enough to work around those who are speed bumps along the way. Adrenaline junkies with a a few of these qualities: a sense of humor, excellent coding skills, lots of patience, the ability to skip sleep cycles, willing to pick up the slack from others, ability to communicate clearly, and take the heat of those who call you on the carpet and question your integrity. The few and the proud.

I have been lucky in my career to have surrounded myself with quality developers with these qualities.

The question pestering me today: how many IT Miracles are we allowed in our careers? Reading my earlier conclusion about the possibility all projects are IT Miracles has me thinking I should be praying there is no limit.

Fortunately most of my clients have reasonable expectations. For this I am blessed. I am sure the next IT Miracle project is just over the horizon so I have decided to enjoy the break in between them this time while I work in projects with sane requirements.

Sep
23

I was surfing the Web this morning looking for the latest images of the International Space Station to see the latest changes done by the crew of STS-115. My hunt lead me across some more transit pictures and actual video of one such transit with the lunar surface as the back drop. Check out the video on Ed Morana’s page to see how fast ISS is traveling when some of these pictures are captured. Very impressive stuff.

Sep
20

Shuttle Atlantis and IIS with the sun as a backdrop. The local weather guy on channel 4 showed this last night on the broadcast and sent me the link (thanks Chuck). I thought taking pictures of lightning was difficult.

If I remember the details correctly: this picture was only possible from a six mile wide slice of Earth for 6 tenths of a second. More details on the Web page with the images.

I am in total awe.

Sep
17

Here it is a late Sunday night in Sterling Heights. I worked hard today painting the outside of the White Light Computing World Headquarters and stained some windows. Manual labor that I am not cut out to be doing (I was born to code).

I am suppose to be working on two projects because I am taking tomorrow off. Instead I get distracted and start surfing the Web. I have no real idea how I got here, but I come across FoxProSuccess.com. I recall reading something about this a while back, but tonight I went through the site.

I really enjoyed reading the different success stories, but I must say I got a big “pick-me-up” when I read Vassilis Aggelakos’ post: VFP does Windows. We have sold very few copies of Deploying Visual FoxPro Solutions, but reading how it impacted Vassilis really made my night! It is posts like this and the emails we get on how the book helped a developer makes the 600+ man hours I worked on the book completely worthwhile.

Anyway, a special thanks to Mike Hogan for creating this site!

Sep
16

It looks like Andrew MacNeill’s and Kevin Ragsdale’s call to bloggers to cover the conferences is really taking off. I thought the Prague coverage by Dave Crozier and Doug Hennig was really good, and the FoxForward “day one” coverage is instantly heating up. Check out Kevin Ragsdale (wall flower, right!), John Koziol (who is giving the behind the scenes of the Fox Team session), and the real behind the scenes coverage by conference organizer Kevin Cully. (any I missed??)

Are there any negative side effects to the bloggers covering the conferences? I started thinking about this a little bit this morning as I was going through the FoxForward posts. Does this mean the UniversalThread coverage is dead? Could be. Is there a need? I see both the Southwest Fox and German DevCon will have official coverages. I know the conference organizers have costs associated with the coverage. With so many bloggers picking up the coverage, why should they add this cost to their already tight budgets? One reason is the bloggers are doing this on-the-fly with no guarantee it will be done. The official UT coverage has deadlines.

I really like the different perspectives. This is much better than just one blogger covering the conference like I did for the Advisor Summit 2006 and German DevCon 2005.

The one thing I disagree with in some of the conference coverage is the concept of doing screencasts of the sessions. I don’t think it would be hard to do with Camtasia, and I doubt it would concern me as a presenter because I could rehearse it before I arrived at the conference. My concerns are with the availability and how this would affect future conferences.

If this material is so readily available to people who don’t attend, what will be the incentive to go to the conference? Sure there is the networking and the ability to ask questions in person. But if the material is accessible about half the incentive to attend will be removed and conference will completely evaporate. I have been involved in many conversations about how the Internet has impacted conferences already. There is so much information easily accessible, so do I really need to attend a conference when I can read someone’s whitepaper online the next week? Same thing with selling the conference proceedings, slides and whitepapers. I want the conferences to flourish and this is completely dependent on attendees attending.

My hope is the conference coverage will make you feel you are really missing the experience and raise your desire to attend. I can tell you this is what the Prague and FoxForward posts are doing to me. Pick a conference and go, they are all good. It is simply the best way to get training on your career.