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: 108
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 ?

Report message to a moderator

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: 21823
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.

Report message to a moderator

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: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
What about changing all text items' case restriction property to upper?

Report message to a moderator

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: 108
Registered: December 2012
Senior Member
I used the suggestion of Mr.Joy ,its work
Thank you All

Report message to a moderator

Previous Topic: Master / Detail Relation question
Next Topic: verification of a date
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 20:45:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.