Yes, I know, this is like swearing in church. This VFP die-hard is doing a VB project.....

But I need some money coming in, so I take what I can get.
Today I ran into a weird problem that I was not able to solve yet.

don't say this problem is nothing, because THAT is what it is all about.

I have this grid, basically it works well.

depending on the value of one of the columns a dataset is filled with a subst from another table. Working still very well. UNTIL!! the field with the value for the subset is empty, null, or, in VB speak NOTHING!

So I check for the fact that the value can be nothing, as in:

IF not (grdOrderMain.currentrow.cells("ordNummer").value.ToString = Nothing) then ...

Well, I get "a bit" a weird errormessage.

As you can see at the bottom of this screen I get this message: "Referenced object has a value of 'Nothing' "

Well, I know that this can happen, I actually checked for that, so please don't you bother me and get on with it.

But no this is VB as in Very Bad. Oh VS makes me Very Sad

Why sad? you might ask. Well, take a look at the picture again. As you can see at the bottom of the screen I checked for this value before, in a previous run. So, being used to the debugger of VFP I expect to see the value there. Well this is VS folks. It wants you to suffer, have pain but no gain, see blood but no money, suffer till the end of your days. Be miserable and sick but never expect mercy from Redmond. They are the snipers! If they can they will shoot you, not to death oh no, 'cause then they would NOt have a toy to toss around.

OH NO, evaluating this automatically could cause side effects, like the developer being productive!! They don't want that, in the MS "wisdom" the decision was made to make the developer do something extra, (s)he needs to reactivate this evaluation.

I would like to tell you that the syllable "dom" is also a Dutch word, it means DUMB!!

Speaking with Gordon Ramsey, it is a f**cking shame!!

OK, after speaking with Simon Arnold I found some other ways to check for values.

none of them worked well:

I just am wondering why I ever would want to be productive???? It would mean I could make a lot of money. I must have gone nuts to wish just that.