none
Another Null RRS feed

  • Question

  • I have been bitten by yet another Null.  I was attempting to assign a column value to a string variable using the following code:

    _strOwner = CStr(MasterBaseTable.Rows(0).Item(8)) 'Article Owner

    I no longer need to assign this data, but I probably should know what needs to be done in the future.  Anyway, this line executes and assigns the column value just fine until..... the column value is null, which causes this exception

    I have tried sever different ways, but have not figured out how to deal with a Null value.  So how would this be done.


    gwboolean

    Saturday, May 18, 2019 10:56 PM

Answers

All replies

  • Hi

    Check out THIS LINK for some info that may help.


    Regards Les, Livingston, Scotland

    • Marked as answer by gwboolean Saturday, May 18, 2019 11:24 PM
    Saturday, May 18, 2019 11:06 PM
  • Wow, that does work, but that sure seems like a lot of activity for something that I believed would be just a matter of setting a property.  Null values seems to weird things out.  I don't know why, but they do.

    Thanks


    gwboolean

    Saturday, May 18, 2019 11:24 PM