Avatar of chalie001
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
Oracle DatabaseSQLDatabasesMongoDB

Avatar of undefined
Last Comment
chalie001

8/22/2022 - Mon
slightwv (䄆 Netminder)

Isn't this the same as your previous question:
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.
chalie001

ASKER
no is not the same i just what to display value in this form in oracle form 6210-14-242-8258
slightwv (䄆 Netminder)

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.
Your help has saved me hundreds of hours of internet surfing.
fblack61
awking00

Can you show some sample values that get inserted and how you would like them to be after an update?
chalie001

ASKER
FM0999-99-999-9999
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
chalie001

ASKER
select regexp_replace(mycol,'([0-9]{4})([0-9]{2})([0-9]{3})([0-9]{4})','\1-\2-\3-\4')
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.