Don,

Any none-SQL command can see buffered data. For example, you can COPY TO into temp table and then run SELECT on it. A query cannot see buffered data because it doesn't use already open tables/cursors but rather opens them similar to USE AGAIN.

>
>Thanks for the quick reply. I don't know that my client's ready (yet) to upgrade to 9, so I may be stuck.
>
>What I found disconcerting about all of this was that I could SCAN the ca's cursor and see the modified values, yet I couldn't SELECT them.
>
>Oh well....
>
>Don