Non-null integer parameter with error message.

  • Hello, I've got an integer parameter that can not be null. How can I get a popup box if the user doesn't enter a value? Something in the same way that strings are checked that can not be empty.

    Thanks.

    Greg

  • That would be something you would do on the client side...  What client-side interaction is occurring?

    Perhaps you want SQL to raise an error and pass a message back to your code.  In that case, have a look at the RAISERROR (i don't think there's a double 'E') TSQL command.

  • RAISERROR ( { msg_id | msg_str } { , severity , state }

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply