>>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.
>
>I'm not sure, but you don't have to specify MyTable.pk = nPk. You can use pk = nPK even if in myCursor is Pk field.
If I leave out the table name I get error "Variable 'PK' is not found". Strange. So the only way, so far, I see using the field PK in the For expression is by qualify it with alias name.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham