>>I am probably missing something very simple (I guess too many hours working today <g>). Here is the situation:
>>
>>

>>* Cursor MyCursor is empty
>>* Table  MyTable has field PK. The first record of MyTable PK is 5
>>* Other record in MyTable have different values of PK (1,2,etc).
>>* The following command is supposed to append records...
>>select MyCursor
>>append from MyTable for MyTable.Pk = nPk
>>* but the above works only if nPk is = 5 (that is, the value in the
>>* first record of MyTable. If I try any other value of nPk, no
>>* records are appended to MyCursor
>>

>>
>>What am I missing?
>>
>>Thank you.



Fabio,

I think that the current filter on MyTable is ignored for the append
All records of MyTable will be appended in the example below
Well, at least in vfp6sp5

>

>SET FILTER TO Pk = m.nPk in MyTable
>select MyCursor
>append from MyTable
>SET FILTER TO in MyTable
>