From: Andy Kramek
Hot Springs Village
Arkansas - United States
To: Bart Rouan
Visual FoxPro 6
General VFP Topics
Monday, September 06, 2004 1:03:30 PM
This message was rated by:
> 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?
> E.G. SET FILTER TO TABLE.FIELD = .NULL. ??????????
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:
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:
'No Record Found'
Microsoft MVP (Visual FoxPro)
Akron, OH, USA
Posted by Bart Rouan @ 9/6/2004 11:11:17 AM
Posted by Mz @ 9/6/2004 11:26:02 AM
Posted by Bart Rouan @ 9/6/2004 1:01:02 PM
Posted by Andy Kramek @ 9/6/2004 1:03:30 PM