Re: Null value into an integer variable

[BB <adamnt42@xxxxxxxxx>]

On 19/4/24 6:50 pm, BB wrote:
> On 19/4/24 6:25 pm, Mayost Sharon wrote:
>
> > Hello
> >
> >
> > Public Sub Main()
> >       Dim sVar As String
> >    Dim iVar As Integer
> >
> >    sVar = "gb"
> >    iVar = 3
> >       sVar = Null
> >    iVar = Null
> >    End
> >
> >
> > When I put an Null value into a variable of type string I don't get 
> > an error and the variable gets a value of ""
> >
> > But when I put an Null value into a variable of integer type it gives 
> > an error
> >
> > Is this normal?
> >
> > Thank you
> Very much so! A string of zero length is considered a null or vice 
> versa a null is considered a string of zero length. But consider the 
> internal (memory) representation of an integer. There is no way to 
> represent a null value.
>
> This is of course a big PIA when dealing with databases where integer 
> columns can contain nulls and that has a very specific meaning i.e. 
> "no value has been set". I have to date, after some time considering 
> this, have not arrived at a viable solution.
>
> Why do you want to set an integer variable to Null?
>
> b
By the way, you are hereby charged with thread stealing and will be 
tried and summarily executed!