>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.

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

INSERT INTO MyCursor SELECT * FROM MyTable WHERE Pk = m.nPk