Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle Forms : 2 Base Table ; Query on either Base Table??

Oracle Forms : 2 Base Table ; Query on either Base Table??

From: Lim Chin Yee <ccelimcy_at_nus.edu.sg>
Date: Thu, 4 Feb 1999 12:06:12 +0800
Message-ID: <3447D7F0AFD4D011AE0400608C14CE560CC4CF03@pfs01.ex.nus.edu.sg>


hi,
i am creating a form which contains 2 base tables and i wanna allow query on either

	item q_code on base table 1(block 1)
or	item b_code on base table 2(block 2)

I know that i could write a trigger in the post-query of both blocks to populate the respective items on either block(depending on which block the query is on)

but, in such case, oracle form would prompt me for an 'save changes message'
the problem is, the values exists in the tables...and should not be saved
how do i overcome this prob??
thanks! Received on Wed Feb 03 1999 - 22:06:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US