| Pre Insert In Oracle Form [message #630627] |
Wed, 31 December 2014 23:36  |
 |
Nasir.azeem
Messages: 40
Registered: September 2014
Location: Karachi
|
Member |
|
|
TYPE
--------
CHNL
REGN
RSM
AM
RM
IF RM AMOUNT IS INSERT THEN ABOVE ALL TYPE (AMOUNT) WILL INSERT FOR EXAMPLE:
TYPE AMOUNT
---------------
CHNL 6000
REGN 5000
RSM 4000
AM 3000
RM 2000
THEN
TYPE AMOUNT
---------------
CHNL 8000
REGN 7000
RSM 6000
AM 5000
RM 2000
ABOVE ALL COLUMN INSERT EXCEPT RM
HOW CAN I USE PRE INSERT TRIGGER IN ORACLE FORM
REGARD
NASIR.
|
|
|
|
| Re: Pre Insert In Oracle Form [message #630641 is a reply to message #630627] |
Thu, 01 January 2015 09:58  |
 |
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
How can you use it? By putting some code into it, obviously.
As Forms triggers are PL/SQL, you'll have to develop a solution which will do what you want. I didn't quite understand what you want to do (i.e. where did those AMOUNT values come from), but I believe you know exactly what you need. Therefore, start writing code, test it, fix bugs. Repeat that process until you have a working code. I'd suggest you to do that in SQL*Plus, not Forms; when it works, simply copy it into Forms.
If you can't figure out what you did wrong, copy code you wrote over here (please, format it and use [code] tags to preserve formatting so that we could easily read it. If you're unsure of how to do it, here you are). Someone will assist.
|
|
|
|
| Re: Pre Insert In Oracle Form [message #630695 is a reply to message #630627] |
Sat, 03 January 2015 02:30 |
 |
jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum
|
Senior Member |
|
|
atleast tell us what you tried and what you got and
provide table script and data and .fmb file on which
you are working so that we can help you.
meanwhile as per your query following can be the solution:-
update tablename
set amount=amount+(select amount from tablename where typ='RM')
where typ<>'RM'
[Updated on: Sat, 03 January 2015 02:58] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
