Solved

vc++ ado NULL

Posted on 2002-04-29
26
429 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 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

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

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

Unlike C#, C++ doesn't have native support for sealing classes (so they cannot be sub-classed). At the cost of a virtual base class pointer it is possible to implement a pseudo sealing mechanism The trick is to virtually inherit from a base class…
In days of old, returning something by value from a function in C++ was necessarily avoided because it would, invariably, involve one or even two copies of the object being created and potentially costly calls to a copy-constructor and destructor. A…
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…
The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.

627 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