I have a form set as "private data session". I am loading the selected record from the database into a form object.

I have written a method to check the change date of the data object verses the record stored in the table to determine if someone else has already modified and saved the record prior to allowing an update request.

However, my problem is when I load a specific record in the form, use a different session to modify the record, the 1st form session does not see the changes in the table even though I've completely closed the 2nd session and the changes are in the database.