Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle Forms : 2 Base Table ; Query on either Base Table??
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