OraFAQ Forum: Forms » Making Initcaps

Home » Developer & Programmer » Forms » Making Initcaps

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Making Initcaps [message #201390]

Fri, 03 November 2006 20:56

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

Report message to a moderator

Re: Making Initcaps [message #201403 is a reply to message #201390]

Sat, 04 November 2006 00:56

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

Report message to a moderator

Re: Making Initcaps [message #201692 is a reply to message #201403]

Mon, 06 November 2006 06:59

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

Report message to a moderator

Re: Making Initcaps [message #201693 is a reply to message #201692]

Mon, 06 November 2006 07:04

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: Making Initcaps [message #201695 is a reply to message #201692]

Mon, 06 November 2006 07:10

Littlefoot
Messages: 21818
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

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 ?

Report message to a moderator

Re: Making Initcaps [message #201927 is a reply to message #201886]

Tue, 07 November 2006 07:33

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

Report message to a moderator

Re: Making Initcaps [message #202068 is a reply to message #201927]

Wed, 08 November 2006 01:38

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

Report message to a moderator

Previous Topic:	Validate Multiple Record Block.
Next Topic:	How to suppress Undefined key

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:33:20 CDT 2024