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

this doesn't work because APPEND FROM read file's data,
help doc is:
APPEND FROM FileName

not from an alias, then it can't see SET FILTER, SE KEY , INDEX ...
Every reference on the FOR clause it is applied to the alias,
and it is constant because the alias record pointer don't change
during the APPEND execution.

Example,

CREATE CURSOR byby (aa i)
ON ERROR ? MESSAGE(),"command: ",MESSAGE(1)
APPEND FROM DBF("byby")

* error
APPEND FROM byby