Results 1 to 31 of 31

Thread: [RESOLVED] Who writes a Case statement like this?

Threaded View

  1. Jun 6th, 2013, 07:45 AM #17
    Zvoni
    Zvoni is offline
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    5,263

    Re: Who writes a Case statement like this?

    Quote Originally Posted by Doogle View Post
    @Sam: You may run the risk of 'Invalid use of Null' on the initial assignment if the status returned from the Table is null.
    Not if he turns on the Error-Handler. Then in Case of Null strFunding would stay blank

    Code:
    On Error Resume Next
strFunding = rsProductsRiders!Status
If strFundingType = "C" Then strFundingType = "N"
If strFundingType <> "W" And strFundingType <> "N" Then strFundingType = "S"
On Error Goto 0
    Last edited by Zvoni; Jun 6th, 2013 at 07:48 AM.
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width