Home » Developer & Programmer » Forms » create trigger on table at runtime
create trigger on table at runtime [message #258673] Mon, 13 August 2007 06:06 Go to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
hi all
i use form 6i database 10g .
how can i create trigger on table at runtime
thax
rafeek
icon14.gif  Re: create trigger on table at runtime [message #258712 is a reply to message #258673] Mon, 13 August 2007 07:48 Go to previous messageGo to next message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member

See the FORMS_DDL built-in function.


Cheers
Sanka

[Updated on: Mon, 13 August 2007 07:49]

Report message to a moderator

Re: create trigger on table at runtime [message #258713 is a reply to message #258673] Mon, 13 August 2007 07:49 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you think twice about it? Why would you want to do something like that?

Think again, until you figure out you don't want to do that at all.

If you had the EXECUTE IMMEDIATE in mind, well, it isn't supported in client-side programs. You might create a script and call it through the HOST command. Or, create a stored procedure which would create a trigger (and you'd call this stored procedure from one of forms triggers).

But once again - I'm quite sure you do not want to do that.
Re: create trigger on table at runtime [message #258946 is a reply to message #258673] Mon, 13 August 2007 19:09 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you want to create it or enable it at runtime? There is a big difference in performance.

David
Previous Topic: reports6i
Next Topic: Unable to enter text
Goto Forum:
  


Current Time: Sat Dec 10 12:31:09 CST 2016

Total time taken to generate the page: 0.09511 seconds