please i need help
i'm new with designer
i make a module using designer 10g
i have two items
item1 is employee salary
i want to make item 2 synchronize with item 1
I know it is very easy when using forms builder
but i do not know how to make it in designer
thanks in advance
I think you'll need to be clearer about what you are trying to do. I take it that when employee salary changes, something else needs to change too. I also think that you are probably using the Forms Generator. But beyond that, you haven't provided enough information for a good answer.
I have two Fields
Filed number one is Employee name and it is a bound field.
Field number two is x_employee_name and it is unbound field.
I want filed number two to be synchronized with field number one
In other words , when field number one is changed , Field number two will change automatically to be like field number one
This is called synchronization
This is very easy when using Forms Builder, it is just a property.
But in designer, it is not exists.
I do not want to write code on post-change or any trigger.
Edited by: email@example.com on May 27, 2009 10:19 AM
I use the Web PL/SQL generator, not the Forms generator, so I'm not totally sure that this will work for you, but this is easy to do. When you define the unbound item, define it as a SQL Expression. Then use whatever function that will fill the unbound item the way you want. For instance, I have bound items NAME_FIRST, NAME_MIDDLE, and NAME_LAST, and want to create an unbound item to display them as a single string. So my SQL Expression is
NAME_FIRST||' '||NAME_MIDDLE||' '||NAME_LAST
You can even use a DECODE function or a CASE expression if you need some logic.
My unbound happens to be display only. It can be made updatable, but that WOULD require a trigger to do something with the data, like update a bound item - no way around it.