Link to home
Start Free TrialLog in
Avatar of Anupama Misra
Anupama Misra

asked on

Hindi font not supported in forms12c

I want search At character press in forms 6i
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image

Oracle Forms 6i (and other versions also) support searching (queries) by default.  We aren't sure what you mean by "At character press ".  Can you explain that?
Avatar of Anupama Misra
Anupama Misra

ASKER

We press A then all the records shows starting with A
Do you understand how Oracle Forms does queries by default?  In Oracle Forms, you start searches (queries) by pressing the [Enter Query] key.  That clears data (if any) from the block and allows you to enter whatever pattern you want to search for in any fields that are queryable. If the pattern you provide is only a portion of the full value, you must also provide the multi-character wildcard indicator for Oracle, which is the "%" (percent) sign.  If you want to find all names that start with "A", you would enter "A%".  Then press [Execute Query] and Oracle Forms does the query for you.

But no, we don't get to change the way that Oracle Forms works.  So no, when the form is in normal (that is "data entry" mode) we don't get to enter a search pattern, then have the form display records matching that pattern.

"Data Entry" mode and "Enter Query" mode are the two different modes of operation that Oracle Forms uses.  Either one can be active, but only one at a time.

Oracle Forms also includes the LOV (List-Of-Values) object.  These can be created and attached to any field in the form.  These allow filtering based on the first character (or characters) that you provide.  LOVs in Oracle Forms work with the form in either "Data Entry" or "Enter Query" mode.
I have non datsbase block we use cursor to display data in block but we still want to search by pressing any character like A
It sounds like you are trying to do things in Oracle Forms that don't match up with how Oracle Forms works best.

Why use a non-database block to display multiple records based on a cursor?  Couldn't that be a database block, possibly based on a view?  If you don't need the block to support inserts, updates or deletes, those are easy to disable.
Oracle Forms6i is a very powerful data query, data entry and data editing tool.  It will do most of the work for you if you use database blocks.

Yes, Oracle Forms also supports “control” or non-database blocks.  Many of the Forms I have developed or worked on include a non-database block, usually for “global” variables or to help with Form-to-Form navigation.

However, I don’t recommend using non-database blocks in Oracle Forms to manage sets of records that come from a database.  Yes, this is possible, but it will require a lot of custom code and/or triggers.

Can you describe what business and/or data problem you have that you think a non-database block in Oracle Forms will handle better than a database block can do?
You apparently changed the title of your question here after you placed this question.   Originally, the title was more like what you described: "Search At character press in forms 6i".

If you are now asking about supporting the Hindi font in Forms12c, that is a totally different question.  You should post that as a separate question if you want help with that.  I have no experience with other fonts in Oracle Forms.
I agree with previous comment.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.