Automatic Row Fetch (ARF) [message #442185] |
Fri, 05 February 2010 03:59 |
BBMamun
Messages: 94 Registered: February 2010 Location: Dhaka, Bangladesh
|
Member |
|
|
Hi Experts
I prefer using oracle provided facilities in Apex. I like to use Automatic Row Fetch process to populate DML form page by clicking a button depending on user parameter and update/delete the record accordingly as we did in Oracle Forms Execute_Query procedure. Any help...Please
Hasan Al MAmun
|
|
|
Re: Automatic Row Fetch (ARF) [message #442214 is a reply to message #442185] |
Fri, 05 February 2010 06:56 |
gtrianta
Messages: 7 Registered: January 2010
|
Junior Member |
|
|
The build in automatic row fetch of APEX is based on a simple concept. If the primary key is populated from the caller (in URL parameters) the page behavior is like you press EXECUTE-QUERY in forms. In that mode you can update or delete the current record. Then you can user a hidden variable (with values UPDATE/DELETE) to hide/show the update or delete buttons accordingly.
If the primary key is not populated from the caller then the page behavior is again like in forms. You are presented with an empty form ready to accept a new record.
So I guess you can simulate all functions in APEX.
Regards
George
|
|
|