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....
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.