Yes, I think there must be some buffers prevent the SQL statement select the right data. So I have to use the value list instead of SQL statement. Because I will allow the user rollback all the modification when they press cancel.
Thanks Barbara, Carig and Nadya. And I have a new question will be posted and hope can get your help also. :)