Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: Bart Rouan
  Where is Bart Rouan?
 South Africa
 Bart Rouan
Subject: RE: .NULL.
Thread ID: 50808 Message ID: 50829 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Monday, September 06, 2004 1:03:30 PM         

Hi Bart

> I have cretaed a view that uses 2 tables they are linked up with a unique field, the problem I have is that the one that I have started archiving from so this means that in the view I might have a record that look at "nothing" and then creates a .NULL. value, I want to keep these .NULL. values seperate on my report byt I do not know how to handle them?

You have to use the ISNULL() function to test whether a field contains a NULL or not. So a filter to get only records with NULL values would have to look like this:
SET FILTER TO ISNULL( table.field )

Note that you can also use the NVL() function to substitute a more useful value for .NULL. - for example you could have the report print "No Record Found" by using NVL as the expression for a field like this:
NVL( view.field, 'No Record Found' )

Andy Kramek
Microsoft MVP (Visual FoxPro)
Akron, OH, USA


.NULL. Posted by Bart Rouan @ 9/6/2004 11:11:17 AM
RE: .NULL. Posted by Mz @ 9/6/2004 11:26:02 AM
RE: .NULL. Posted by Bart Rouan @ 9/6/2004 1:01:02 PM
RE: .NULL. Posted by Andy Kramek @ 9/6/2004 1:03:30 PM