Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: jurgen meyer
  Where is jurgen meyer?
 Manila
 Philippines
 jurgen meyer
 To: Jamie Osborn
  Where is Jamie Osborn?
 Melbourne
 Australia
 Jamie Osborn
 Tags
Subject: Thanks everybody
Thread ID: 33613 Message ID: 33658 # Views: 0 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Monday, December 01, 2003 2:33:01 PM         
   


Thanks everybody, my problem is solved.

Jurgen Meyer.


> > > When I read information from Access MDB file and create a table in VFP,I sometime I get .NULL. in some of the field. When I tried to clean up the table in VFP I ran into a problem. I don't know how to test the field which is .NULL., I have tried to test whether the field is empty, or contains something but failed. Can anyone tell me how to test a field whether it is .NULL. or not? I want to empty such field or it will crash my app.
> > >
> > > Many thanks.
> > >
> > > Jurgen Meyer
> > >
> >
> > if Isnull(filedname)
> > your satements
> > endif
>
> NVL() might help you out also. It is an optimised version of :
>
> IIF(ISNULL(myfield),"",myfield)
> 

> which helps you to not get stung by null values.
>
> Cheers,
> Jamie
> jamie.osborn@foxite.com


ENTIRE THREAD

How to test a field whether it is .NULL. or not Posted by jurgen meyer @ 11/30/2003 1:57:57 PM
RE: How to test a field whether it is .NULL. or... Posted by Rene Relucio @ 11/30/2003 2:03:11 PM
RE: How to test a field whether it is .NULL. or... Posted by Jamie Osborn @ 12/1/2003 6:19:54 AM
Thanks everybody Posted by jurgen meyer @ 12/1/2003 2:33:01 PM