You exactly got the point Mark. I am very specific on details. This is the reason why I needed the exact data that were committed to the base tables. There are some procedures that needed precise and up to date records to process.

I already tried to execute the sqlexec() again after the base tables were changed but still the record that is being returned to the query does not include the latest update of the base tables.

What I do is to close the system and open it again and re execute the sqlexec() and by that, the last record modified will be included in the query.

I guess I have to live by this fact...
Thanks by the way....