Home » Developer & Programmer » Forms » Making Initcaps
Making Initcaps [message #201390] Fri, 03 November 2006 20:56 Go to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi,

I developed and entry form in which Expense_Name is an entry. I want to make the entries of the field value in Initcap.

like if somebody enters annual maintenance
then it comes like Annual Maintenance.

Any clues?

Bye
Ashu
Re: Making Initcaps [message #201403 is a reply to message #201390] Sat, 04 November 2006 00:56 Go to previous messageGo to next message
kishorebagul
Messages: 3
Registered: November 2006
Location: SURAT (INDIA) - (GUJARAT)
Junior Member
it is so easy , please follow below steps
1. please select item which u want to set initcaps
2. item must be item type =TEXT ITEM and data type=CHAR
3. go to property by right click
4. go to functional group and look at CASH RESTRICTION u can change it

now ur initcaps is set for this item
Re: Making Initcaps [message #201692 is a reply to message #201403] Mon, 06 November 2006 06:59 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi Kishore,

Thanks for the help but it has only three case u can set

1. Upper
2. Mixed
3. Lower

So what I want is not solved from that . My question is make the expense name as Initcap

If I enter 'purchased computer' then it should be like
'Purchaed Computer'

Bye
Ashu
Re: Making Initcaps [message #201693 is a reply to message #201692] Mon, 06 November 2006 07:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I have no idea about Forms/Reports whatever.
But this can be done easily in database.
scott@9i > select initcap('purchased computer') from dual;

INITCAP('PURCHASED
------------------
Purchased Computer
Re: Making Initcaps [message #201695 is a reply to message #201692] Mon, 06 November 2006 07:10 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use Oracle INITCAP function:
SQL> select initcap ('annual maintenance') from dual;

INITCAP('ANNUALMAI
------------------
Annual Maintenance

SQL>

As you want it in a form, write a WHEN-VALIDATE-ITEM trigger which would have something like this in it:
:emp.ename := initcap(:emp.ename);


[EDIT] I apologize; it seems to be an exact copy of Mahesh's message, but is not - a colleague took me a few minutes before pressing the "Reply" button.

[Updated on: Mon, 06 November 2006 07:12]

Report message to a moderator

Re: Making Initcaps [message #201886 is a reply to message #201692] Tue, 07 November 2006 03:57 Go to previous messageGo to next message
kishorebagul
Messages: 3
Registered: November 2006
Location: SURAT (INDIA) - (GUJARAT)
Junior Member
Hi Ashu..

then u can set in SQL like this


1* select initcap('kishore bagul') from dual
SQL> /

INITCAP('KISH
-------------
Kishore Bagul


------------------------------------------------------

please tell me r u developing in ORACLE/DEVELOPER ?
and where r u from ?
Re: Making Initcaps [message #201927 is a reply to message #201886] Tue, 07 November 2006 07:33 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi Kishore,

I am working in Oracle 9i and Developer 2000. I am from Kanpur but working in Pune.

bye

Hi Littlefoot and Mahesh

I am very thankfull to both of you. Yes I want it in form and now it solved.

Bye
Ashutosh Trivedi
Re: Making Initcaps [message #202068 is a reply to message #201927] Wed, 08 November 2006 01:38 Go to previous message
kishorebagul
Messages: 3
Registered: November 2006
Location: SURAT (INDIA) - (GUJARAT)
Junior Member
hi. Ashutosh


I m profession in oracle/Developer too at surat.

So please send your mail id for
better professional relasionship.


Yours Truly

KISHORE BAGUL
Previous Topic: Validate Multiple Record Block.
Next Topic: How to suppress Undefined key
Goto Forum:
  


Current Time: Tue Dec 06 04:51:58 CST 2016

Total time taken to generate the page: 0.12711 seconds