>>>>cCursor1 must be read-write cursor for this to work.
>>>
>>>The customer claims that this worked before and now stopped working. Is it at all possible that the syntax APPEND FROM (as I have) could work?
>>
>>The syntax you have is correct and it should work as is. However, INSERT-SQL is 100% bullet-proof and APPEND FROM is 99,9% bullet-proof.
>
>What makes the APPEND FROM to be 0.01 less bullet-proof? What has changed (which possibly have changed) that made this code stop working? I realize that you may not have the answer but I just tried the program on my computer (with the old APPEND FROM code) and it works. Thank you for your help.

I think there may be two reasons

1. The cursor was created without NOFILTER keyword and produced the filter on the actual table

2. Something is wrong with the temp path (say, too many files or temporary not-accessible).