I seem to have stumbled across a bug in VFP5.0 - can anyone please confirm this behavior and/or give some explanation?
issue the following code:
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.
Anxiously awaiting confirmation/explanation.
thanks!
Ken B. Matson
GCom2 Solutions