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
 Tags
Subject: How to test a field whether it is .NULL. or not
Thread ID: 33613 Message ID: 33613 # Views: 0 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Sunday, November 30, 2003 1:57:57 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



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