Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Christian Tabligan
  Where is Christian Tabligan?
 Bacolod City, Neg. Occ.
 Philippines
 Christian Tabligan
 To: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 Tags
Subject: RE: Filtering .NULL.
Thread ID: 112408 Message ID: 112491 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Thursday, November 09, 2006 1:32:39 AM         
   


> > Hi Christian
> >
> > Not sure what you want to do
> >
> > But you can use
isnull()
function to check the fields
> >
> >
> > Mustapha Bihmouten

>
> In VFP9 SQL, you can also use the IS NULL statement:
>
> SELECT yourfields ;
> FROM yourtable ;
> WHERE somefield IS NULL ;
> 	AND NOT otherfield IS NULL ;
> INTO CURSOR result
> 

> --
> Eric den Doop
> www.foxite.com - The Home Of The Visual FoxPro Experts


thanks a lot sir!

Christian M. Tabligan
Programmer, Central Lumber Corp.-Cebu City

Visual FoxPro is like a game...need to explore until you reach your goal to success!!!

ENTIRE THREAD

Filtering .NULL. Posted by Christian Tabligan @ 11/8/2006 10:18:54 AM
RE: Filtering .NULL. Posted by Mustapha Bihmouten @ 11/8/2006 10:34:34 AM
RE: Filtering .NULL. Posted by Eric den Doop @ 11/8/2006 11:52:16 AM
RE: Filtering .NULL. Posted by Christian Tabligan @ 11/9/2006 1:32:39 AM