473,231 Members | 1,826 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

IIF Function

I am using the IIF function in my application to create an instance and
value of a field if it doesn't exist in the query. I am using a
datagrid to display 4-5 items at a time and if one of the items doesn't
have a revision listed in tblRevisions then the whole page errors out.
I am using the following to try and fix the problem:

Dim intADCN As Integer =
IIf(ds1.Tables("DataTable").Rows(0)("RevNumber") Is Nothing, 0,
ds.Tables("DataTable").Rows(0)("RevNumber"))

I am getting an error: Cast from type 'DBNull' to type 'Integer' is not
valid. It seems as though instead of creating the instance and value of
0, it is simply creating the instance of there being an a row there and
the value is null.

Am I missing something or does anyone have any suggestions?

Nov 19 '05 #1
5 3997
Taken from your example, this will return 0 if the value is Null, else the
value:
Dim intADCN As Integer = "0" & ds1.Tables("DataTable").Rows(0)("RevNumber")
"Sparky Arbuckle" <tw*@secureroot.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
I am using the IIF function in my application to create an instance and
value of a field if it doesn't exist in the query. I am using a
datagrid to display 4-5 items at a time and if one of the items doesn't
have a revision listed in tblRevisions then the whole page errors out.
I am using the following to try and fix the problem:

Dim intADCN As Integer =
IIf(ds1.Tables("DataTable").Rows(0)("RevNumber") Is Nothing, 0,
ds.Tables("DataTable").Rows(0)("RevNumber"))

I am getting an error: Cast from type 'DBNull' to type 'Integer' is not
valid. It seems as though instead of creating the instance and value of
0, it is simply creating the instance of there being an a row there and
the value is null.

Am I missing something or does anyone have any suggestions?

Nov 19 '05 #2
I fixed it!

Dim intRevNumber As Integer

If ds.Tables("DataTable").Rows(0)("RevNumber") Is DBNull.Value Then
intRevNumber = 0
Else
intRevNumber = ds.Tables("DataTable").Rows(0)("RevNumber")
End If

Nov 19 '05 #3
Pat
Good Buddy

"Sparky Arbuckle" <tw*@secureroot.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
I fixed it!

Dim intRevNumber As Integer

If ds.Tables("DataTable").Rows(0)("RevNumber") Is DBNull.Value Then
intRevNumber = 0
Else
intRevNumber = ds.Tables("DataTable").Rows(0)("RevNumber")
End If

Nov 19 '05 #4
> Dim intADCN As Integer = "0" &
ds1.Tables("DataTable").Rows(0)("RevNumber")
Turning Option Strict Off is extremely bad practice, and the above code is a
horrible example of why. You're treating BOTH a string and possibly Nothing
as an Integer. You're also occasionally concatenating Nothing to a String.
This sort of coding can lead to all kinds of debugging headaches, as well as
not throwing exceptions that should be thrown, thus enabling your app to
pass the smell test in testing, and fail behind your back in production.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"Chris Botha" <ch***********@AThotmail.com> wrote in message
news:eH**************@TK2MSFTNGP14.phx.gbl... Taken from your example, this will return 0 if the value is Null, else the
value:
Dim intADCN As Integer = "0" &
ds1.Tables("DataTable").Rows(0)("RevNumber")
"Sparky Arbuckle" <tw*@secureroot.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
I am using the IIF function in my application to create an instance and
value of a field if it doesn't exist in the query. I am using a
datagrid to display 4-5 items at a time and if one of the items doesn't
have a revision listed in tblRevisions then the whole page errors out.
I am using the following to try and fix the problem:

Dim intADCN As Integer =
IIf(ds1.Tables("DataTable").Rows(0)("RevNumber") Is Nothing, 0,
ds.Tables("DataTable").Rows(0)("RevNumber"))

I am getting an error: Cast from type 'DBNull' to type 'Integer' is not
valid. It seems as though instead of creating the instance and value of
0, it is simply creating the instance of there being an a row there and
the value is null.

Am I missing something or does anyone have any suggestions?


Nov 19 '05 #5
I've been doing this since the days of VB6 and ADO, no problems yet.
Thanks for the comments though.

"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:ec**************@TK2MSFTNGP15.phx.gbl...
Dim intADCN As Integer = "0" &
ds1.Tables("DataTable").Rows(0)("RevNumber")


Turning Option Strict Off is extremely bad practice, and the above code is
a horrible example of why. You're treating BOTH a string and possibly
Nothing as an Integer. You're also occasionally concatenating Nothing to a
String. This sort of coding can lead to all kinds of debugging headaches,
as well as not throwing exceptions that should be thrown, thus enabling
your app to pass the smell test in testing, and fail behind your back in
production.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.

"Chris Botha" <ch***********@AThotmail.com> wrote in message
news:eH**************@TK2MSFTNGP14.phx.gbl...
Taken from your example, this will return 0 if the value is Null, else
the value:
Dim intADCN As Integer = "0" &
ds1.Tables("DataTable").Rows(0)("RevNumber")
"Sparky Arbuckle" <tw*@secureroot.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
I am using the IIF function in my application to create an instance and
value of a field if it doesn't exist in the query. I am using a
datagrid to display 4-5 items at a time and if one of the items doesn't
have a revision listed in tblRevisions then the whole page errors out.
I am using the following to try and fix the problem:

Dim intADCN As Integer =
IIf(ds1.Tables("DataTable").Rows(0)("RevNumber") Is Nothing, 0,
ds.Tables("DataTable").Rows(0)("RevNumber"))

I am getting an error: Cast from type 'DBNull' to type 'Integer' is not
valid. It seems as though instead of creating the instance and value of
0, it is simply creating the instance of there being an a row there and
the value is null.

Am I missing something or does anyone have any suggestions?



Nov 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: domeceo | last post by:
can anyone tell me why I cannot pass values in a setTimeout function whenever I use this function it says "menu is undefined" after th alert. function imgOff(menu, num) { if (document.images) {...
5
by: phil_gg04 | last post by:
Dear Javascript Experts, Opera seems to have different ideas about the visibility of Javascript functions than other browsers. For example, if I have this code: if (1==2) { function...
2
by: laredotornado | last post by:
Hello, I am looking for a cross-browser way (Firefox 1+, IE 5.5+) to have my Javascript function execute from the BODY's "onload" method, but if there is already an onload method defined, I would...
2
by: sushil | last post by:
+1 #include<stdio.h> +2 #include <stdlib.h> +3 typedef struct +4 { +5 unsigned int PID; +6 unsigned int CID; +7 } T_ID; +8 +9 typedef unsigned int (*T_HANDLER)(void); +10
8
by: Olov Johansson | last post by:
I just found out that JavaScript 1.5 (I tested this with Firefox 1.0.7 and Konqueror 3.5) has support not only for standard function definitions, function expressions (lambdas) and Function...
3
by: Beta What | last post by:
Hello, I have a question about casting a function pointer. Say I want to make a generic module (say some ADT implementation) that requires a function pointer from the 'actual/other modules'...
2
by: f rom | last post by:
----- Forwarded Message ---- From: Josiah Carlson <jcarlson@uci.edu> To: f rom <etaoinbe@yahoo.com>; wxpython-users@lists.wxwidgets.org Sent: Monday, December 4, 2006 10:03:28 PM Subject: Re: ...
28
by: Larax | last post by:
Best explanation of my question will be an example, look below at this simple function: function SetEventHandler(element) { // some operations on element element.onclick = function(event) {
4
by: alex | last post by:
I am so confused with these three concept,who can explained it?thanks so much? e.g. var f= new Function("x", "y", "return x * y"); function f(x,y){ return x*y } var f=function(x,y){
7
by: VK | last post by:
I was getting this effect N times but each time I was in rush to just make it work, and later I coudn't recall anymore what was the original state I was working around. This time I nailed the...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.