>Hi
>
>
>I have some code that does an append from for a condition . this is appending 0 records.
>If I paste the same condition onto the end of a select it returns three records
>
>Any ideas what could be causing that behaviour I expected the same result in both (the select is returning the correct result)
>
>Thanks
>
>Nick
>.

Sounds like a missing NOFILTER or READWRITE. Please show the actual code.