?
Solved

vc++ ado NULL

Posted on 2002-04-29
26
Medium Priority
?
435 Views
Last Modified: 2010-04-02
I have worked in  VB 6.0 ADO ,there i found a method ISNULL to check a field item is null or not.
I am currently in VC++ 6.0 Ado, i am not able to find such a method . How could i test a field is
null.
0
Comment
Question by:v_iyengar
  • 13
  • 6
  • 4
  • +2
26 Comments
 
LVL 30

Expert Comment

by:Axter
ID: 6976884
if (ptr == NULL)
{
}
0
 

Author Comment

by:v_iyengar
ID: 6976895
i want to check if Fields->GetItem(0l)->Value is null
0
 
LVL 30

Expert Comment

by:Axter
ID: 6976899
if (Fields->GetItem(0l)->Value == NULL)
{
}
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 30

Expert Comment

by:Axter
ID: 6976900
If you want to check if the return value of GetItem is null then you can do the following:
if (Fields->GetItem(0l)== NULL)
{
}
0
 
LVL 30

Expert Comment

by:Axter
ID: 6976903
If Value is a non-pointer, then I think what you're looking for is something like this.

if (Fields->GetItem(0l)== NULL)
{
  MyValue = Fields->GetItem(0l)->Value;
}
0
 
LVL 30

Expert Comment

by:Axter
ID: 6976905
Oops!  Correction:
if (Fields->GetItem(0l) != NULL)
{
 MyValue = Fields->GetItem(0l)->Value;
}
0
 

Author Comment

by:v_iyengar
ID: 6976948
i want to check with database null
0
 
LVL 30

Expert Comment

by:Axter
ID: 6976956
>>i want to check with database null
What do you mean?

What ever you have as a pointer, should be checked to see if the value equals to NULL.
0
 

Author Comment

by:v_iyengar
ID: 6976964
the value for an item in database can be NULL.
How can i check its null
Fields->GetItem(0l)->Value is a VARIANT ,how can i compare a VARIANT and NULL
0
 
LVL 3

Expert Comment

by:GGRUNDY
ID: 6976968
I think in the case of a NULLable charater field the variant type returned will be of type VT_NULL if the field is NULL.
0
 

Author Comment

by:v_iyengar
ID: 6976969
the value for an item in database can be NULL.
How can i check its null
Fields->GetItem(0l)->Value is a VARIANT ,how can i compare a VARIANT and NULL
0
 

Author Comment

by:v_iyengar
ID: 6976975
the value for an item in database can be NULL.
How can i check its null
Fields->GetItem(0l)->Value is a VARIANT ,how can i compare a VARIANT and NULL
0
 

Author Comment

by:v_iyengar
ID: 6976981
the value for an item in database can be NULL.
How can i check its null
Fields->GetItem(0l)->Value is a VARIANT ,how can i compare a VARIANT and NULL
0
 

Author Comment

by:v_iyengar
ID: 6976987
yes vt type is set to VT_NULL
But will all database will do the same,set VT to VT_NULL or i have to check some other code like scode
0
 

Author Comment

by:v_iyengar
ID: 6976997
yes vt type is set to VT_NULL
But will all database will do the same,set VT to VT_NULL or i have to check some other code like scode
0
 

Author Comment

by:v_iyengar
ID: 6977029
yes vt type is set to VT_NULL
But will all database will do the same,set VT to VT_NULL or i have to check some other code like scode
0
 
LVL 3

Expert Comment

by:GGRUNDY
ID: 6977092
Sorry but after lots of ploughing through documentation I can't find anything which gives me confidence that comparing against VT_NULL will be reliable in all weather. But I'm guessing it will probably be as reliable as your original VB test was.
0
 

Author Comment

by:v_iyengar
ID: 6977363
yes vt type is set to VT_NULL
But will all database will do the same,set VT to VT_NULL or i have to check some other code like scode
0
 

Author Comment

by:v_iyengar
ID: 6977374
so you mean ISNULL in vb only test for VT=VT_NULL
0
 
LVL 3

Expert Comment

by:GGRUNDY
ID: 6978558
As VB uses a variant type internally that is my suspicion.
0
 

Author Comment

by:v_iyengar
ID: 6979518
so u mean to say its enough if i check VT=VT_NULL ?
0
 
LVL 3

Accepted Solution

by:
GGRUNDY earned 100 total points
ID: 6979759
No ....
I mean that's what "I" would do x.vt == VT_NULL,
but I would do it without great confidence because the
documentation is really crappy.
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7036271
Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,

** Mindphaser - Community Support Moderator **

P.S.  Click your Member Profile, choose View Question History to go through all your open and locked questions to update them.
0
 

Author Comment

by:v_iyengar
ID: 7040973
i am also doing the same,but i do not know is it correct?
0
 
LVL 11

Expert Comment

by:griessh
ID: 7122187
I suggest to split between Axter and GGRUNDY

======
Werner
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7138107
Force accepted

** Mindphaser - Community Support Moderator **

Axter, there will be a separate question with points for your help.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is the first in a series of articles about the C/C++ Visual Studio Express debugger.  It provides a quick start guide in using the debugger. Part 2 focuses on additional topics in breakpoints.  Lastly, Part 3 focuses on th…
  Included as part of the C++ Standard Template Library (STL) is a collection of generic containers. Each of these containers serves a different purpose and has different pros and cons. It is often difficult to decide which container to use and …
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.
The viewer will be introduced to the technique of using vectors in C++. The video will cover how to define a vector, store values in the vector and retrieve data from the values stored in the vector.
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question