MS Access & Triggers [message #2734] |
Thu, 08 August 2002 12:10 |
Yaling
Messages: 3 Registered: August 2002
|
Junior Member |
|
|
Hello All,
I have an Oracle database with an Access 97 Data Entry front end. The Oracle database includes the following tables:
Data_Entry
ACTION
APPT
The goals are once data are inputed into the Access form, the data will be sent to Oracle table Data_Entry and the triggers (after insert row) will fired and send data from Data_Entry table to LOA table and APPT table.
Before I enabled the triggers, the system works well and the data could be sent to Data_Entry table as soon as I input it into the Access form. But after I enabled the triggers, the data couldn't be sent to Data_Entry table from the form.
Why is this so? Is this a problem of the trigger or a problem of ODBC? When I insert data into Data_Entry in Oracle, the triggers work well. The trigger code is as follows:
create or replace trigger trig_action
after insert on DATA_ENTRY
for each row
begin
insert into PSC_ACTION
values (:new.action_id,
:new.action_code,
:new.action_auditor,
:new.action_time_stamp
);
end;
.
run
Thanks in advance for your help!
Yaling
|
|
|
|