chalie001
asked on
set item in form
how can i set value to this after insert
6210-14-242-8258
set item emp to be in this format after i insert which trigger must i use
6210-14-242-8258
set item emp to be in this format after i insert which trigger must i use
ASKER
no is not the same i just what to display value in this form in oracle form 6210-14-242-8258
If you want to physically update the data to add the dashes in the table on insert, then the form should just be able to display what it receives without any format masking.
If this is what you want to do, you should be able to apply the formatting inside the form and insert the data in the desired format. I remember you asked a question on how to do that. I just cannot find it.
I've not used forms for many years but are you wanting forms triggers or database level triggers?
If database level triggers:
If you cannot get forms to insert the data correctly, as a last resort you should be able to create a before insert trigger. You might need an after insert trigger if forms interferes with the before trigger.
If this is what you want to do, you should be able to apply the formatting inside the form and insert the data in the desired format. I remember you asked a question on how to do that. I just cannot find it.
I've not used forms for many years but are you wanting forms triggers or database level triggers?
If database level triggers:
If you cannot get forms to insert the data correctly, as a last resort you should be able to create a before insert trigger. You might need an after insert trigger if forms interferes with the before trigger.
Can you show some sample values that get inserted and how you would like them to be after an update?
ASKER
FM0999-99-999-9999
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
select regexp_replace(mycol,'([0- 9]{4})([0- 9]{2})([0- 9]{3})([0- 9]{4})','\ 1-\2-\3-\4 ')
https://www.experts-exchange.com/questions/29008102/inserting-value-in-table-in-oracle-form.html
I remember other questions that were very similar about screen masking versus inserting the data.