Home » Developer & Programmer » Forms » Insert DATA in my DB on uppercase format (oracle forms 10g ,win xp pack 2)
Insert DATA in my DB on uppercase format [message #580059] Tue, 19 March 2013 14:53 Go to next message
goldray
Messages: 104
Registered: December 2012
Senior Member
Hi,
I have a datablock based , I used commit_form(); to insert data in my DB .
But,I want to insert data into my DB on uppercase format!!

Any suggestions ?
Re: Insert DATA in my DB on uppercase format [message #580060 is a reply to message #580059] Tue, 19 March 2013 14:56 Go to previous messageGo to next message
Littlefoot
Messages: 19350
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One option is to create a BEFORE INSERT (and possibly UPDATE) database trigger which will force conversion to uppercase letters using the UPPER function.
Re: Insert DATA in my DB on uppercase format [message #580062 is a reply to message #580059] Tue, 19 March 2013 15:13 Go to previous messageGo to next message
joy_division
Messages: 4490
Registered: February 2005
Location: East Coast USA
Senior Member
What about changing all text items' case restriction property to upper?
Re: Insert DATA in my DB on uppercase format [message #580066 is a reply to message #580062] Tue, 19 March 2013 15:43 Go to previous message
goldray
Messages: 104
Registered: December 2012
Senior Member
I used the suggestion of Mr.Joy ,its work
Thank you All
Previous Topic: Master / Detail Relation question
Next Topic: verification of a date
Goto Forum:
  


Current Time: Sat Aug 02 00:25:01 CDT 2014

Total time taken to generate the page: 0.10320 seconds