Hi

I had a strange problem with a program an discovered that the index had been created on a numeric value while the seek() was searching for a character expression. I got the following strange results when Zero was one of the values in the table. Is this a bug in the Seek() function?

I am using VFP 7.0 SP1 and WinXP Pro SP1. I get the same results in VFP 8.0 SP1.

Create Table UPTest (Number N(5,0))
Select UPTest
Index On Number Tag Number
Insert Into UPTest (Number) VALUES (1)
Insert Into UPTest (Number) VALUES (2)
Insert Into UPTest (Number) VALUES (3)

? Seek("Mary","UPTest","Number")    && .F. as expected

? Seek("mary","UPTest","Number")    && .F. as expected

? Seek("0Mary","UPTest","Number")    && .F. as expected

Insert Into UPTest (Number) VALUES (0)

? Seek("Mary","UPTest","Number")    && .T.  ???

? Seek("mary","UPTest","Number")    && .T.  ???

? Seek("0Mary","UPTest","Number")    && .T.  ???


Clear All
Delete File UPTest.dbf
Delete File UPTest.cdx