I have seen threads here before pertaining to whether a cursor created with "select into cursor" can be used with append from. Previous posters said that you need to use the nofilter clause to force the cursor to disk, and also, I believe, that you need to include the dbf() function in your syntax

e.g.
select * from customer into cursor mycursor nofilter
select mytable
append from dbf('mycursor')


I have similar code as follows:

=afields(larespmatr,"respmatr")
Create cursor currespmatr from array larespmatr
Select currespmatr
Append from respmatr for cresphdrid=lc_cresphdrid &&respmatr is a table in the database


Then later on:

select respmatr
append from dbf('currespmatr')


This code seems to work - 'almost all the time'. But my client called with a problem (the code didn't fail or hang there) that seemed to indicate that the append from dbf('currespmatr')line must have failed, because the expected records weren't there.

So my question is: will a cursor created with create cursor have the same problem as a cursor create with select into cursor?. Create cursor doesn't have a nofilter clause.


But, I suppose, it is also possible that the missing records could have resulted from the 'append from respmatr' line also.

Respmatr is a table that is open already. Should I use:
append from dbf('respmatr')


TIA