From: Bart Rouan
Visual FoxPro 6
General VFP Topics
Monday, September 06, 2004 1:01:02 PM
This message was rated by:
> > 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
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).
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