OraFAQ Forum: Forms » How to make the system SMART??

Home » Developer & Programmer » Forms » How to make the system SMART??

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

How to make the system SMART?? [message #167493]

Thu, 13 April 2006 06:35

Rose_250
Messages: 17
Registered: April 2006

Junior Member

Hii every body,

Can you please tell me how to make the system smart?
For example,
101 means courses that relate to Computer Science Department
102 means courses that relate to Computer Engineering Department

You want to enter this course number 0101110.

But, While you are starting to enter the number in Field name, for example (Course ID), and when you reached to 0101
(you didn't continue writing the number) the system should show all courses that relates to computer science in a list..

Can any body tell me how to make it please?

Report message to a moderator

Re: How to make the system SMART?? [message #167505 is a reply to message #167493]

Thu, 13 April 2006 07:26

RAS_SANKAR
Messages: 42
Registered: March 2006
Location: India

Member

i think better u place the listbox instead of textbox. so that u have no need to enter course id.

Report message to a moderator

Re: How to make the system SMART?? [message #167508 is a reply to message #167505]

Thu, 13 April 2006 07:43

Maaher
Messages: 7065
Registered: December 2001

Senior Member

A LOV would be my choice. It has built-in filtering. If you want a true autocomplete feature you need a Javabean or a OCX/ActiveX control.

A listbox would indeed also work.

MHE

[Updated on: Thu, 13 April 2006 07:43]

Report message to a moderator

Re: How to make the system SMART?? [message #167593 is a reply to message #167508]

Fri, 14 April 2006 05:16

Rose_250
Messages: 17
Registered: April 2006

Junior Member

Thanks Mr.Ras and Mr. Maaher for your replaies..
> About doing the Listbox
What if I have hundred of Courses can I group them by Department in order to gain the result I want?

> About doing LOV
Actually, this is the first time for me to use developer2000 and I don't Know how to use all its tools (including Lov and JavaBean or ActiveX control), But I will try to do it.. Razz

Thanks again..

Report message to a moderator

Re: How to make the system SMART?? [message #167595 is a reply to message #167593]

Fri, 14 April 2006 06:03

Maaher
Messages: 7065
Registered: December 2001

Senior Member

A LOV is Forms built in component. First you define a record group. This is the query you want to use or you define fixed values. Create a LOV using this record group. You define what fields invoke the LOV and what items receive the selected column values. Forms has a LOV wizard. Hitting F1 in Forms builder might help out too. Look at contents. Choose "Designing Forms"->"List of Values"

MHE

Report message to a moderator

Re: How to make the system SMART?? [message #167674 is a reply to message #167595]

Sat, 15 April 2006 05:27

Rose_250
Messages: 17
Registered: April 2006

Junior Member

Thaks Mr. Maaher I appreciate your replies. .

Report message to a moderator

Previous Topic:	how run my complied form in my system and user system
Next Topic:	Invoke SWF files in Form 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:53:22 CDT 2024