Home » Developer & Programmer » Forms » F10 trigger (oracle 10g win xp)
F10 trigger [message #402322] Fri, 08 May 2009 14:09 Go to next message
muzaffar2010
Messages: 16
Registered: May 2009
Location: usa
Junior Member
hello

how to execute pl\sql code key pressed?


i want to insert data into table when i press F10 key.




muzaffar
Re: F10 trigger [message #402367 is a reply to message #402322] Sat, 09 May 2009 08:03 Go to previous messageGo to next message
klat
Messages: 87
Registered: May 2009
Location: Mumbai
Member

Hi,

What is your actual problem.
F10(KEY-COMMIT) will insert data into the table.

Re: F10 trigger [message #402368 is a reply to message #402367] Sat, 09 May 2009 09:02 Go to previous messageGo to next message
muzaffar2010
Messages: 16
Registered: May 2009
Location: usa
Junior Member
hi

under key-commit trigger

begin

insert into f(name,id) values(:text_item4,:text_item5);
commit;
end;


when i press F10 nothing happens!!!!!

the same code under when-button-pressed trigger it works

did you have any suggestion?

thanks
Re: F10 trigger [message #402372 is a reply to message #402368] Sat, 09 May 2009 10:30 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
what is the version of oracle, forms you are using?
Re: F10 trigger [message #402375 is a reply to message #402368] Sat, 09 May 2009 10:53 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
muzaffar2010
under key-commit trigger <LF: some_code_here>

when i press F10 nothing happens!!!!!

Is F10 mapped to KEY-COMMIT?
Re: F10 trigger [message #402383 is a reply to message #402375] Sat, 09 May 2009 12:35 Go to previous messageGo to next message
muzaffar2010
Messages: 16
Registered: May 2009
Location: usa
Junior Member
hi

the version is oracle 10g (2.3.0.10.0)


Re: F10 trigger [message #402384 is a reply to message #402375] Sat, 09 May 2009 12:41 Go to previous messageGo to next message
muzaffar2010
Messages: 16
Registered: May 2009
Location: usa
Junior Member
hi


Is F10 mapped to KEY-COMMIT?

that is what i found after doing some search.

what do you think?

thanks
Re: F10 trigger [message #402432 is a reply to message #402384] Sun, 10 May 2009 07:26 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't think anything. It is you who should know

/forum/fa/6180/0/
  • Attachment: frm_keys.PNG
    (Size: 4.50KB, Downloaded 2549 times)
Previous Topic: pdf files for forms
Next Topic: Fill all fields
Goto Forum:
  


Current Time: Fri Sep 20 10:27:03 CDT 2024