You need to add the keyword NOFILTER to your SELECT statement.


>I have noticed a strange behaviour while using SELECT command. I have a table called SPHIST, which has about 200,000 records. I use a command like this
>
>SELECT * from SPHIST where VIN = "1234" INTO CURSOR ABC
>
>The query should select one record (as there is only one record in SPHIST for the matching VIN). It does create a cursor ABC with one record. I see one record when I browse the table. However, FoxPro links the ABC cursor to SPHIST and applies a filter (VIN = "1234"). The status bar shows
>
>ABC (database!SPHIST) Record: 161518/214052
>
>In most cases, it does not affect the speed. However, if I use a commands like this:
>
>USE SomeTable
>APPEND FROM DBF('ABC')
>
>It starts appending the entire SPHist table instead of a single record.
>
>This behaviour (of applying a Filter instead of creating a new cursor) does not happen always.
>
>Has anyone faced something similar? Any workaround?
>
>Thanks.
>
>- Ravi