Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Rene Relucio
  Where is Rene Relucio?
 Quezon City
 Philippines
 Rene Relucio
 To: jurgen meyer
  Where is jurgen meyer?
 Manila
 Philippines
 jurgen meyer
 Tags
Subject: RE: How to test a field whether it is .NULL. or...
Thread ID: 33613 Message ID: 33614 # Views: 0 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Sunday, November 30, 2003 2:03:11 PM         
   


> 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

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