Hello Everyone, We have employee records stored in a "PAY:Employee" form. The Status is either "Active" or "Inactive". The employees each have a unique "Employee e-ID" field. The problem is that some of our employees are, alas, no longer with us, so we want to mark their Statuses as "Inactive?
So we have a control panel with a table that displays all the "Active" records. The "Employee e-ID" value is listed in an "Employee e-ID col" column. The user hi-lites the rows he wants to make inactive, and clicks a "De-Activate" button. This calls an active link that calls a guide that loops the table. For each hi-lited record an "inner" active link pushes the value "Inactive" to the record where 'Employee e-ID' = $EmployeeEid col$. The main active link then refreshes the table, and the hi-lited records disappear. If you display them they have indeed been changed to "Inactive". At least that is the way it worked in our test system. We have now brot everything over to the live system, and all the active links fire, and the log shows the link pushing the "Inactive" value to the desired records. BUT the records don't get updated. They do not disappear from the table and when you display them their Status is still "Active." I ran a filter log just in case some other workflow was setting the Status back again, but it wasn't. Besides, the "Last Modified Date" is not getting set. I inserted a message into the "inner" active link to print out the "Employee e-ID col" and it is correct. But the Push Fields is simply not happening. I am running as Administrator, so it can't be a permissions issue. Any ideas? (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
