Hi,
I'm pretty new to Apex and cannot find a solution for this challenge:
I have an Apex Form with several fields, one of them is named STATUS: VARCHAR2(1) which I am displaying as a switch Y/N.
If the user moves the switch to ‘Y’, then after they click ‘Apply Changes’ I need to be able to look through all of the records in the current table and find any existing records with a current value of ‘Y’ in the STATUS field and then update that field to ‘N’. IOW, only one record in this table can have a STATUS value of ‘Y’ at any given time.
I think that a Page Process is what I need to utilize but I don't know how to ensure the current record that just got committed with a ‘Y’ doesn't also get changed back to ‘N’ during the SQL script.
Please bear with me. I realize I might not even be on the right path here.
Thanks
Doug