Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bart Rouan
  Where is Bart Rouan?
 Gauteng
 South Africa
 Bart Rouan
 To: Mz
  Where is Mz?
 Metro Manila
 Philippines
 Mz
 Tags
Subject: RE: .NULL.
Thread ID: 50808 Message ID: 50828 # Views: 2 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Monday, September 06, 2004 1:01:02 PM         
   


> > Hi all
> >
> > 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. ??????????
> >
> > Please any help would be appreciated.
> > Bart Rouan
> > South Africa
>
> rather you could use
>
>
> SET FILTER TO EMPTY(TABLE.FIELD)
> 

>

Okay...here comes more detail

I have a view with two tables, when I have a left join (this runs also a lot faster) the view returns the dbtdet fields and matching dbtheda records, the problem is that becuase of my archiving facility that I have created for the client the query returns in certain instances a .NULL. value in a carater field, when I join the two tables with a inner join the results are perfect but it is extremely slow....... I am lost for ideas, also when I > SET FILTER TO EMPTY(TABLE.FIELD) I get the same error message that the cardno can not be .NULL. (think it might be because it is a caracter field).

Bart Rouan
South Africa

ENTIRE THREAD

.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