Solved

vc++ ado NULL

Posted on 2002-04-29
26
428 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 25 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Which IDE to use to begin C++ training? 5 70
best sources to up-to-date in C++? 8 104
max float value 3 60
I could not set window to top 4 45
Written by John Humphreys C++ Threading and the POSIX Library This article will cover the basic information that you need to know in order to make use of the POSIX threading library available for C and C++ on UNIX and most Linux systems.   [s…
C++ Properties One feature missing from standard C++ that you will find in many other Object Oriented Programming languages is something called a Property (http://www.experts-exchange.com/Programming/Languages/CPP/A_3912-Object-Properties-in-C.ht…
The goal of the tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
The viewer will learn additional member functions of the vector class. Specifically, the capacity and swap member functions will be introduced.

696 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