OraFAQ Forum: Forms » With bring full name with 3 initial letters

Home » Developer & Programmer » Forms » With bring full name with 3 initial letters

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

With bring full name with 3 initial letters [message #82835]

Tue, 08 July 2003 11:54

Anju
Messages: 33
Registered: September 2000

Member

HI friends,
In my forms what I have to do is if user types initial 3 letters of company name or whatever then it should bring all company name matches with that three letters.
Suppose company name is computer dept. ltd, communication ltd. etc, so when user types �com� in the company_name field then it should bring up both company name or if there is one company with that initial then that company name.
Urgently in need of help!
Thanks in advance.
Anju

Report message to a moderator

Re: With bring full name with 3 initial letters [message #82838 is a reply to message #82835]

Tue, 08 July 2003 13:45

Julie
Messages: 98
Registered: February 2002

Member

If you put a lov on the field, and set it to validate to list, and they type 3 characters and then tab, this functionality will happen automatically.

Report message to a moderator

Re: With bring full name with 3 initial letters [message #82841 is a reply to message #82835]

Tue, 08 July 2003 23:18

Sun
Messages: 92
Registered: August 2002

Member

U can write in key next item - execute query;

and in pre query - u can write default where clause

and u can proceed..

I have not tried.. but u can try..

Report message to a moderator

Re: With bring full name with 3 initial letters [message #82859 is a reply to message #82838]

Wed, 09 July 2003 22:59

Anju
Messages: 33
Registered: September 2000

Member

Thanks, it worked.
Anju

Report message to a moderator

Previous Topic:	Cursor restriction...
Next Topic:	Forms 5 runtime gives GPF (DrWatson)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 19 08:20:50 CST 2025