Solved

Check Box event in Oracle forms

Posted on 2011-02-23
6
1,151 Views
Last Modified: 2013-12-19
I am new to oracle forms
I am trying to add a check-box event in a from built using table X. And my check-box is a non-database item that is not present in table X.

Now when checked it should enter a record into a Y table. If that event is in table Y it should be checked on post-query trigger.
Similarly when unchecked it should delete a record from table Y

And also I need to check a variable x1='.....' in table x that has to check with variable y1='.......' from table Y.

If the question is not clear then let me know..
0
Comment
Question by:r211
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 20

Expert Comment

by:flow01
ID: 34963387
What is your question ?

What do you want to happen when  the check in the post-query is false ?
0
 

Author Comment

by:r211
ID: 34963912
Post-Query trigger to check if the event is in the table when check box is checked

I wanted to know how to write those requirements in when-checkbox changes trigger. How to write it when it is using a table Y apart from using table X as object.
0
 
LVL 20

Accepted Solution

by:
flow01 earned 250 total points
ID: 34965696

a hint how it might look

when checkbox changed

begin
  if  :yourblock.checked = 'Y'
    insert into Y
      (col1, col2, ....)
    values
      (:yourblock.keyvalue1,  'fixedvalue2', ...);
  else
   delete from Y where col1 = :yourblock.keyvalue1;
end;


post_query

   begin
      select 'Y' into :yourblock.checked
      from Y where col1 = :yourblock.keyvalue1;
  exception when no_data_found then
      :yourblock.checked := 'N';
  end;
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Closing Comment

by:r211
ID: 34969534
Thank you...
0
 

Author Comment

by:r211
ID: 34973810
Thank you so much for your help...it worked...
0
 

Author Comment

by:r211
ID: 35008798
I have few more questions related to this question...

In X table on which the form was built contains 15 rows in which evt_name is the primary key

In Y table on which the check-box created has only 2 rows in which evt_name is the foreign key to this table.

Now I can insert or delete only one row that is present in both the tables. How can I insert other events that are not in table Y but present in table X
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question