| CONDITIONS [message #156910] |
Sun, 29 January 2006 20:55  |
LLOYDL
Messages: 1
Registered: November 2005
|
Junior Member |
|
|
question?
first table
code
LC001
LC002
LC003
second table
exam_code
ahc0001
ahc0002
i build a trigger
if :amst_amb_queues.dept_code = 'ADM' and
:amst_amb_queues.item_code= :item_code then
_____________________________in this statement how can i manipulate the file maintenance that i made if i call
LC001 ITS EQUAL TO SECOND TABLE
AFTER THE CONDITION SATISFY GOING TO NEXT =>
misc_proc_ins_results_perexam(:amst_amb_queues.cs_no,:amst_amb_queues.item_code);
forms_ddl('commit');
:global.cs_no:= :amst_amb_queues.cs_no;
:global.item_code:=:amst_amb_queues.item_code;
commit;
call_form ('');
end if;
THANKS
|
|
|
|
| Re: CONDITIONS [message #156921 is a reply to message #156910] |
Sun, 29 January 2006 22:52  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Did you even look at your post after you submitted it?
Please read the sticky concerning how to present table definitions and table data, and use 'code' tabs to reformat your post. When I can read it, I'll answer it. By the way, what was the name of the trigger?
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
