Author Published on Leave a comment

It's been quite a while since I sat down and wrote in the blog! Since early December I have been absolutely buried in work for a client, but I'm finally getting to the end of it. Should finish up with it this week and be able to re-group and see what's next on the agenda.

I wrote software for this client which they have been using for the past 5-6 years and they are now starting to lease it out to other companies in the same field. So we had to do some polishing on the program, make sure everything was compatible with Vista and Windows 7. Installers were improved and all binaries code signed. We also upgraded the application from SQL Anywhere 9.0.2 to 11.0.1.

This software was originally written by Sue between 1996 and 2000 using TPS files and ClaCom for transmitting data from remote users. When I started working on the SQL version of this software back in 2002 we decided to use Crystal Reports, but we found out later that it was next to impossible to deploy it, but it wasn't a big deal since they just bought the Standard Edition of Crystal Reports for the computers so it was not a big deal. Now it seems that it is impossible to get the Standard Edition so I set out to try to come up with a better solution and see if I could figure out how to deploy this. After some snooping around I found out that Crystal Reports Xi came with deploy-able merge modules and after some more research I found out that I could use Visual Studio 2010 to create an MSI installer with the merge modules. Testing showed that it worked perfectly so we deployed this new MSI installer. It adds about 40MB to the install, but everyone using this is on high speed internet connection so downloading 65MB install is not a problem.

We converted the new company to use the software two weeks ago and everything went smoothly except they had to use some old hardware for the database server as their new server had been delayed - once delivered last week it turned out to be defective so this is taking some extra time. There have been some minor issues that have come up, nothing major, but we have had to make some modifications to the program and the database after we deployed because this company operates a bit differently than my client's company. Dealing with outdated hardware has prompted us to decide that when we do this again we will buy a computer to set this up on and get it completely set up before we deliver it so that everything is working perfectly when we hand it over. This doesn't deal with a lot of data (accumulated total number of all records in all tables for both companies is < 100,000) As I mentioned, the software uses SQL Anywhere 11.0.1 and we use the Sybase Replication (dbremote) to transmit data from remote computers to a consolidated database via FTP server. The remote users are brokers that work remotely, transmitting trade orders to the back office where they are processed. We have been using Sybase replication since 2005 without a single problem, it just works, so this has worked perfectly for our application. I need to finish off a report and do an update for the new company and then I should be mostly done with this client for now, apart from regular maintenance:) I have several outstanding issues that I need to deal with in the tools from PowerOffice as well as new updates for Utilities and Build Automator. I will be starting to work on those again next week and hopefully I can get back on schedule with my products by the beginning of February. I appreciate the patience whle I have been going through an extremely busy period for the past 4-6 weeks! Arnor Baldvinsson

Author Published on Leave a comment

Sue and I send you all our best wishes for Merry Christmas and Happy
Holidays this season:) May we all enjoy a prosperous New Year in 2011:)

Once I have posted this I am going to be out of the office until Tuesday, December 28. I will probably check my email couple of times over the long weekend, but don't expect speedy support;)

Thank you all for your business and support in 2010:)

Arnor Baldvinsson - Susan Pichotta
Icetips Alta LLC

Author Published on Leave a comment

I use Skype quite a bit for all kinds of contact with clients and programmers and it has become part of my life. I just found out that it has been down all day, at least for me and millions of other users. Click here to read more about this problem on the Skype blog.

Here are couple of other links that have some more information:

http://blogs.wsj.com/digits/2010/12/22/skype-down-for-millions-of-users/

http://blog.tmcnet.com/blog/tom-keating/skype/skype-down.asp

Hopefully they will get it back up again soon:)

Arnor Baldvinsson

Author Published on Leave a comment

I have uploaded the latest builds of all our products. Taskpanel was already Clarion 7.3 compatible from an install earlier this month and was not updated now. All the other products now have a Clarion 7.3 compatible installer. I did not release any other changes to the products, except the Previewer, so if you have the latest build and don't need the 7.3 compatibility, you do not have to download this build.

The only change in the Previewer this time was a minor fix for the "Condition for use" option in the Legacy template chain which was not working correctly. It is now:)

For more information and download links to each of the new version, please visit our forum.

With these builds the total number of builds released this year for our subscribers climbs to 51! I'm hoping to get one more documentation update for the Icetips utilities out before the end of the year. In 2009 we released 24 new builds, 11 in 2008 and 21 in 2007. That is 107 builds since we started with our subscriptions in late July 2007.

As we are getting close to Christmas and we are getting busy with holiday stuff, Sue and I want to wish you all Merry Christmas and a very prosperous New Year:)

Arnor Baldvinsson and Susan Pichotta
Icetips Alta LLC

Author Published on Leave a comment

We have made version 2.0.143 of Icetips Taskpanel available for download at http://www.icetips.com/downloadfile.php?FileID=155.

You need to have a valid Gold subscription and be logged into your Icetips account to be able to download the new install. To purchase a Gold Subscription please go to http://www.icetips.com/subscribe-gold.php and to renew, please go to http://www.icetips.com/renewsubscriptions.php

You can access the documentation online in html format and you receive the chm and PDF files with the install.

To read more about the Taskpanel update, please view my post on our forum Note that this install is the first of Clarion 7.3 compatible installs. We have tested all our installs and products under Clarion 7.3, as I blogged about earlier. We have just received a second Clarion 7.3 pre-release build which should fix the threading issue that we found when testing our Previewer demo! I will test it later today and expect to push out all the new builds for Clarion 7.3 tomorrow if no problems are found:)

This version of the Taskpanel changes a bit the way ampersands in headers and items are now shown. There was a problem with this in the older versions and since the ampersands made no sense as hot-keys, I have changed this so that ampersands are always shown exactly like they are entered into the headers and items. I.e. "Name & Address" will show up exactly like that. "Name && Address" will show up as "Name && Address". If this change causes issues, please let me know as soon as possible!

Arnor Baldvinsson

Author Published on Leave a comment

Last week I have tested all our products with the new Clarion 7.3 build. Everything is working nicely, except I stumbled on a thread dead-lock bug in the Clarion run-time library. Softvelocity reported to me Friday morning that this problem has been isolated and fixed for next build! It does not affect any of our products, but the Report Previewer demo demonstrated this dead-lock very well and it was 100% reproducible. I was also able to reproduce it with the People.app demo application Thursday and submitted that to Softvelocity and they have tested it with their new build with no problems at all! So I am confident that our 7.3 builds will have no problems at all:)

Since none of our products add any Clarion libraries, the DLL/LIB name changes in 7.3 do not affect any of our products.

I have updates for the PowerToolbar and Previewer ready to go, but decided to wait releasing them when Softvelocity announced that 7.3 pre-release was around the corner. I will release those updates in the next day or two as the public 7.3 release is probably some time away and I don't want to wait for it.

I'm planning to release a new build of the Utilities before the end of the month with documentation updates. Other products will be released as new features will be ready for release or when 7.3 is released to the public, then the new 7.3 compatible installs of all products will be made available!

Arnor Baldvinsson

Author Published on Leave a comment

Hi all,

We have made version 1.1.2392 of Icetips Utilities available for download at http://www.icetips.com/downloadfile.php?FileID=154

You need to have a valid Gold subscription and be logged into your Icetips account to be able to download the new install. To purchase a Gold Subscription please go to http://www.icetips.com/subscribe-gold.php and to renew, please go to http://www.icetips.com/renewsubscriptions.php

This build is mostly documentation update, which is now up to even 400 pages in the PDF! You can access the documentation < href ="http://www.icetips.com/manuals/utilities/index.html" target="_blank">online in html format and you receive the chm and pdf files with the install.

To read more about the Utilities update, please view my post on our forum This build is the 40th build that we release this year!

I have new builds of the Previewer and Taskpanel that will be going out either this week or next. I had some issues reported last week that I felt like taking care of before I released new updates. That has been taken care of now:)

Clarion 7.3 is expected to be released this week to third party developers for testing. New install builds will be required to support Clarion 7.3 and that will put the number of builds issues by Icetips to over 50 in 2010! For a Gold Subscription renewal price, that gives you a new build for about $3.00!

Arnor Baldvinsson

Author Published on Leave a comment

I don't know about you, but I have had to fight procrastination most of my life! There, I've said it! It can not only reduce your productivity, it can completely remove it. It's easy to fall into it. It's particularly easy after being sick for extended period of time, meaning more than the 2-3 day being-sick-with-the-flu thing.

After being sick with pneumonia this fall and having to be away from work for somewhere around a month simply because I did not have the energy to do it, it was extremely difficult for me to get up again and off the couch and get productive again.

Procrastination can be caused by many things. Overwhelming projects, never ending backlog of things that need to be done yesterday, over-committing, bad time management, bad planning skills... the list goes on. Programmers often tend to have problems with time management and time estimates. Which is why most programmers have to deal with slipping deadlines - we are too optimistic about our abilities. "This will only take an hour" we say and two days later we are still not done with it! We hit unexpected problems, uncooperative tools, incomprehensible code that we wrote 10 years ago and we have absolutely no clue what the heck we were smoking back then;)

We blatantly ignore the fact that there are only 24 hours in a single day and in a blazing explosion of optimistic egomania we sit down Monday morning and note down 14 tasks that we are absolutely going to finish tomorrow. We tell our clients that we'll have all of this done by tomorrow at 5PM, completely ignoring the fact that we know that the first 5 tasks will take at least 10 hours to complete, EACH! And the other 9 will take at least an hour each. So we have, without problem, squeezed 59 hours of work into a 24 hour day and we see absolutely nothing wrong with it.

Tuesday morning comes around and we realize that the first task which we expected to take 10 hours will in fact take 20. So we decide to do some research on how we could perhaps complete it faster. Maybe someone else has tackled this and have posted some code we can use. Google finds 1.5 million solutions and we go through all of them, just to make sure they don't fit. Once we have completed that we realize it's Thursday already and the code is no closer to be done than it was Tuesday morning. We just spent 3 days procrastinating over something we might as well have tackled right away and gotten done.

Next week comes along and again, in our plans, we have managed to carefully compress about 240 hours worth of work into Monday through Thursday, no problem at all! Easy! Monday morning we check the newsgroups and find an interesting thread on comp.lang.clarion about someone who bought a dog that was infected with some extremely rare illness.

300 messages later and after a very heated and heartfelt debate about the fate of the dog, who incidentally died before the thread, we are exhausted from all the drama and need a well deserved break.
Nap and some TV will fix that for sure. It's Thursday by now, again... After a long nap we wake up exhausted and grumpy. The day is gone, the week is gone, and all we have to show for it is old news about a dead dog.

We cram 500 hours into Friday and call it a day! A nap in front of the TV. Priceless!

Friday morning we get up depressed and not feeling good about our progress, our client, our project or ourselves. The client called and asked about progress. "Not done yet???" Unexpected problems and lengthy research required. "OK, when will it be done? We need this by the end of next week as we are adding a new install here and need this modification." It'll be done Thursday next week. We finally have to face the fact that we over-committed and procrastinated because our time schedule was completely irrational. We begrudgingly face reality and work our butt off for the next 7 days, get the job mostly done - done enough for the client to be happy with it, or at least that's what they said. A year later we get to thinking about this client and why they never called again... They must have been so happy with our work that they'll never need anything else. Somewhere deep in our subconscious we hear someone scream "YEAH, RIGHT!!!" Must be some background chatter on TV. Wow, did you see that?!

The above is a bit exaggerated but I'm sure many of us have been in some version of this situation at some point in our lives. The question is how to break out of it and become productive again. I could say that I'm procrastinating writing this blog post, but it has a purpose: I intend to use this blog to help me break out of the procrastination habit. Writing gives me an extremely strong feeling of being productive. It invigorates me, it makes me feel energetic and in control. It also gives me a venue to both express myself and also explore things.

What I, and many others, have found over the years is that writing about something makes it easier to understand and come to grips with. How many times do we post technical or support questions on newsgroups or forums or other interactive media, only to realize the answer as we are writing. Writing about the problem forces us to focus on it in a different way than when we just stare at it. It kicks the brain into gear as we explain what the problem is. Doing that we connect different pathways in the brain and often times the answer just pops up. Because we explained the problem to others, and thereby to ourselves, our brain got a fresh perspective on it and figured it out.

So please bear with me as I try to find the best ways for me to fight my tendency to procrastinate and fight the seemingly ever relentless inertia that can so easily keep me from getting things done - things that I really want to get done! Who knows, maybe my posts will give you some fresh ideas. 🙂 I have things to do, places to go. I guess I'm writing this here, because I think the first step in the recovery or healing process is to acknowledge and admit to myself and the world that I have a problem and that I'm determined to fight it and win! On that note, I only have about 34 hours of work scheduled to do tomorrow so it's going to be an easy day. 🙂

Arnor Baldvinsson

Author Published on Leave a comment

I'm sure we have all seen this from time to time! We run our newly compiled program only to have it disappear all of a sudden for no apparent reason. We search and search and search... Finally we find, using whatever debugging methods we choose, that the program goes down when it assigns a value to a variable. Doesn't make any sense at all until we, hours later, realize that the darn variable is a REFERENCE variable! Yep, we accidentally hit the "Reference" checkbox on the column property window.

This looks all so simple and happy, doesn't it?

But there is a deadly problem lurking on that window that is so easy to overlook!

Do you see what it is?

No?

Look again!

The "Reference" checkbox!

In the past years I have probably lost more time to this than anything else and it is nobody's fault but my own!

It happens once in a while and that is the problem. If it happened every day I'd expect it, but it happens perhaps every 3 months or so.

I'm still not sure what I do to accidentally check it! The hot key for it is Alt-F and I'm very used to very quickly hit Alt-F-S to save. Years ago I found that key combination to be easier and more universal than Ctrl-S for Save so I stuck with Alt-F-S and I'm wondering if that's what I'm accidentally doing. Or maybe I accidentally click on it. Don't know.

Whatever the reason is, every so often I check the "Reference" checkbox and it's always when I'm implementing something new. So I, rather logically, assume that it is whatever new I'm adding, not that new variable I just added. After all, what in the world could go wrong when creating a simple variable? As it turns out, quite a lot can go wrong;)

So what happens when you try to assign the "July 31, 2009" date value to a reference variable? Chances are very good that the program is going to fall over in a dramatic way - no GPF, no nothing. It just disappears! It is unlikely that the value 76186 is pointing to anything useful!

It would be nice if a warning message was implemented in Clarion 7 as an option so that it would warn when the Reference checkbox was checked when creating or modifying a variable with something like: "Are you sure you want to create a Reference variable?" or "Are you sure you want to change "Loc:FromDate" into a Reference variable (&Loc:FromDate)?" It would save me some time and definitely some frustration when I accidentally check the "Reference checkbox"!

Happy bug hunting:)

Arnor Baldvinsson