hey developers!!!!!
please help me with this! and thanks in advance. We have a form based on a table SUPPLIERS that holds all data for ours vendors.
The head of the Division requested that he should be the only one to change the data on table SUPPLIERS. Okay. So nobody has
access to the form based on SUPPLIERS but him. Now he wants the other users to submit him requests to change data on a specific
field. So I created a table and a form that has the following fields supplier_code, column, new_value and code. Now the orther users will tell
the supplier code from a pick list, the column to be changed from a pick list and the new value for the field. On a pre-insert trigger i will
generate the update statement with the name of the table and with the name of the column to be updated and save into field code.
The head of the division would press a button that will fire on a when button pressed trigger and will execute
a forms_ddl call with the code. Here is the code for the trigger:
begin
for rec_codigo in (select code from supplier_changes where supplier_code = :supplier_change.request_number) loop
forms_ddl(rec_codigo.codigo);
end loop;
commit;
end;
Very basic coding.
here is a sample os the value of the field code:
update suppliers set E_MAIL_2 = 'A@A.COM' where supplier_code = '0AXF7';
However, it is not working! The supplier table never gets updated! Can't you guys see where it is wrong???? Or give some other approach with this!!!!!
thankssss
{}
gH
Edited by: Gleisson Henrique on Oct 3, 2008 1:53 PM