Null Values From Database

[Randy Rubin]

How do I handle Testing for null values in a database? Here is a Line of
Code:

If Not jNull("JNum") Is DBNull Then

And this is the Error:

BC30684: 'DBNull' is a type and cannot be used as an expression.

Thanks

Randy

[Jos]

"Randy Rubin" <ra***@imarubin.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

How do I handle Testing for null values in a database? Here is a Line of
Code:

If Not jNull("JNum") Is DBNull Then

And this is the Error:

BC30684: 'DBNull' is a type and cannot be used as an expression.

If ( TypeOf jNull("JNum") Is DBNull ) Then

Jos

[z. f.]

any problems with

IsDBNull ( value )

?

"Jos" <jo***************@fastmail.fm> wrote in message
news:%2***************@tk2msftngp13.phx.gbl...

"Randy Rubin" <ra***@imarubin.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

How do I handle Testing for null values in a database? Here is a Line of Code:

If Not jNull("JNum") Is DBNull Then

And this is the Error:

BC30684: 'DBNull' is a type and cannot be used as an expression.

If ( TypeOf jNull("JNum") Is DBNull ) Then

Jos

[Randy Rubin]

This:

If Not IsDBNull(jNull("JNum")) Then
Seemed to work, But now I am getting:

System.InvalidOperationException: Invalid attempt to read when no data is
present

I'm assuming this is because the value is Null... Anymore Ideas?
"z. f." <zi**@info-scopeREMSPAM.co.il> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

any problems with

IsDBNull ( value )

?

"Jos" <jo***************@fastmail.fm> wrote in message
news:%2***************@tk2msftngp13.phx.gbl...

"Randy Rubin" <ra***@imarubin.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

How do I handle Testing for null values in a database? Here is a Line of Code:

If Not jNull("JNum") Is DBNull Then

And this is the Error:

BC30684: 'DBNull' is a type and cannot be used as an expression.

If ( TypeOf jNull("JNum") Is DBNull ) Then

Jos

[Reza Solouki]

Just to give you a little bad news, none of these would work if your type of data is datetime - I am still looking for a solution for this!

"Randy Rubin" wrote:

This:

If Not IsDBNull(jNull("JNum")) Then
Seemed to work, But now I am getting:

System.InvalidOperationException: Invalid attempt to read when no data is
present

I'm assuming this is because the value is Null... Anymore Ideas?
"z. f." <zi**@info-scopeREMSPAM.co.il> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

any problems with

IsDBNull ( value )

?

"Jos" <jo***************@fastmail.fm> wrote in message
news:%2***************@tk2msftngp13.phx.gbl...

"Randy Rubin" <ra***@imarubin.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
> How do I handle Testing for null values in a database? Here is a Line

of

> Code:
>
> If Not jNull("JNum") Is DBNull Then
>
> And this is the Error:
>
> BC30684: 'DBNull' is a type and cannot be used as an expression.

If ( TypeOf jNull("JNum") Is DBNull ) Then

Jos

[Randy Rubin]

Can someone post a code example that will check to see is the row or field
is null?

--Randy

"Reza Solouki" <Re*********@discussions.microsoft.com> wrote in message
news:42**********************************@microsof t.com...

Just to give you a little bad news, none of these would work if your type of data is datetime - I am still looking for a solution for this!
"Randy Rubin" wrote:

This:

If Not IsDBNull(jNull("JNum")) Then
Seemed to work, But now I am getting:

System.InvalidOperationException: Invalid attempt to read when no data is present

I'm assuming this is because the value is Null... Anymore Ideas?
"z. f." <zi**@info-scopeREMSPAM.co.il> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

any problems with

IsDBNull ( value )

?

"Jos" <jo***************@fastmail.fm> wrote in message
news:%2***************@tk2msftngp13.phx.gbl...
> "Randy Rubin" <ra***@imarubin.com> wrote in message
> news:%2****************@TK2MSFTNGP11.phx.gbl...
> > How do I handle Testing for null values in a database? Here is a Line of
> > Code:
> >
> > If Not jNull("JNum") Is DBNull Then
> >
> > And this is the Error:
> >
> > BC30684: 'DBNull' is a type and cannot be used as an expression.
>
> If ( TypeOf jNull("JNum") Is DBNull ) Then
>
> Jos
>
>

[Mark Whitton]

This example is when using a data reader and checks if a field is null

reader.IsDBNull(reader.GetOrdinal(fieldName))

Mark Whitton

"Randy Rubin" <ra***@imarubin.com> wrote in message
news:mR4Qc.1765$aR2.346@okepread04...

Can someone post a code example that will check to see is the row or field
is null?

--Randy

"Reza Solouki" <Re*********@discussions.microsoft.com> wrote in message
news:42**********************************@microsof t.com...

Just to give you a little bad news, none of these would work if your type

of data is datetime - I am still looking for a solution for this!

"Randy Rubin" wrote:

This:

If Not IsDBNull(jNull("JNum")) Then
Seemed to work, But now I am getting:

System.InvalidOperationException: Invalid attempt to read when no data

is present

I'm assuming this is because the value is Null... Anymore Ideas?
"z. f." <zi**@info-scopeREMSPAM.co.il> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
> any problems with
>
> IsDBNull ( value )
>
> ?
>
>
>
> "Jos" <jo***************@fastmail.fm> wrote in message
> news:%2***************@tk2msftngp13.phx.gbl...
> > "Randy Rubin" <ra***@imarubin.com> wrote in message
> > news:%2****************@TK2MSFTNGP11.phx.gbl...
> > > How do I handle Testing for null values in a database? Here is

a Line > of
> > > Code:
> > >
> > > If Not jNull("JNum") Is DBNull Then
> > >
> > > And this is the Error:
> > >
> > > BC30684: 'DBNull' is a type and cannot be used as an expression.
> >
> > If ( TypeOf jNull("JNum") Is DBNull ) Then
> >
> > Jos
> >
> >
>
>