>>CREATE TABLE mytest (tnum N(6) NULL , tdate D)
>>INSERT INTO mytest (tnum, tdate) VALUES (.NULL., {11/15/98})
>>BROW FOR mytest.tnum = 5 AND mytest.tdate > {10/31/98}>On my system - the record incorrectly appears in the browse window! Closing,
>>reopening, etc. doesn't change it. SQL Select and other "For" functions such as
>>SUM, COUNT, etc. seem to work correctly.
>
>Interesting. I think I may tag this one as "By design", but I'll bounce it upwards and see what happens.
>
>I may be thinking about this incorrectly, but I think when it gets to the FOR condition, the test comes out as:
>
>mytest.tnum = 5 AND myTest.tDate > {^1998/10/31}
>.NULL. = 5 AND {^1998/11/15} > {^1998/10/31}
>.NULL. AND .T.
>.NULL.
>
>And if you insert several other lines, and then type BROWSE FOR .NULL. in the command window shows only the line which you added having the .NULL.

Interesting, indeed. I get the same result (running VFP5.0a under Win95). COUNT, SUM, AVERAGE, and SQL all handle it correctly, it's only the BROWSE command which includes the record with .null. in tnum. I did find that it only seems to happen if the record with the .null. is the first record in the table. If I run this test

CREATE TABLE mytest (tnum N(6) NULL , tdate D)
INSERT INTO mytest (tnum, tdate) VALUES (1, {11/14/98})
INSERT INTO mytest (tnum, tdate) VALUES (.NULL., {11/15/98})
INSERT INTO mytest (tnum, tdate) VALUES (3, {11/16/98})
BROW FOR mytest.tnum = 5 AND mytest.tdate > {10/31/98}

the BROWSE window is empty. Must be some anomaly in the BROWSE command.