🚀 go-pugleaf

In article <7cbefb$o3b10@forums.borland.com>, Scott politely paraphrased 
...
> I have this SQL statement below
> 
> select  a.x_partnum, a.x_serial, a.purorder,  a.psno, a.dte_ret, b.vendnum,
> c.vendor, a.val from "&history" a, purorder b, vendor c where a.purorder =
> b.purorder and b.vendnum = c.vendnum and dte_ret IS NOT NULL and credit IS
> NULL
> 
> When I output that to the report that I am doing I don't get any information
> but when I leave out
> 
> and credit IS NULL
> 
> I get some information, but my field for credit, is null because there is
> nothing in that field.  So my orginal sql statement should work but I don't
> know why it doesn't.  Any help on this would be of great use.  Thanks in
> advance.
> 
Which table format? If used on DBF tables of level 3,4 or 5 for example, 
it will be never NULL.
-- 
Romain Strieff [dBVIPS/TeamB]
Please read this newsgroup guide below before 
posting on the private Inprise newsgroups.
http://www.inprise.com/newsgroups/guide.html
--