OraFAQ Forum: Forms » Search field in LOV issue

Home » Developer & Programmer » Forms » Search field in LOV issue

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

Search field in LOV issue [message #676900]

Fri, 26 July 2019 03:19

raszynsky
Messages: 3
Registered: July 2019

Junior Member

Hello!

I'm having a weird problem with a LOV in Oracle Forms 6i. I added new column which has length 2000 and now when i enter LOV i can't see a '%' in a search field. All the names start with the same 3 letters and normally i would see 'ABC%' in a search field and if i typed the first letter of second word i would see a difference like 'ABC word1%' etc. and now it still filters the same way but the search field looks frozen, it still shows only 'ABC'. The funniest point is when i change the length of new column to 317 it works normally, but if i change it to 318 it freezes.

Thanks in advance for any help.

Report message to a moderator

Re: Search field in LOV issue [message #676909 is a reply to message #676900]

Fri, 26 July 2019 07:34

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So, leave it at length 317.

Who will be scrolling that much right, to check what's written at position 1670? I wouldn't want to do that. LoV is designed to help you search for something, not to scroll through vast amount of data manually / visually. 317 is too much as well, in my opinion.

Apart from that useless rant, did you try to compile ALL the form (Ctrl + Shift + K) and see what happens?

Report message to a moderator

Re: Search field in LOV issue [message #676910 is a reply to message #676909]

Fri, 26 July 2019 07:40

raszynsky
Messages: 3
Registered: July 2019

Junior Member

Compile all doesn't help. I added the length of all the columns that are in LOV and their length all together is 2684 (2685 and more makes my problem). I need those columns but i don't show them in LOV. They are used to fill some fields after a choice from LOV. I only show 3 columns in LOV, the rest just fills the fields. Anyway, i checked again and when the total length of columns exceeds 2685, the search field is limited to 4 characters. No idea why Sad

Report message to a moderator

Re: Search field in LOV issue [message #676912 is a reply to message #676910]

Fri, 26 July 2019 07:42

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Aha.

How about another approach? Keep those 3 columns you need in the LoV, and create a WHEN-VALIDATE-ITEM trigger which will populate the rest of items (based on what you select in the LoV). If that works OK, if necessary, add the same code into POST-QUERY block-level trigger so that you'd populate those items on fetch (if those items aren't database items).

Report message to a moderator

Re: Search field in LOV issue [message #676913 is a reply to message #676912]

Fri, 26 July 2019 07:45

raszynsky
Messages: 3
Registered: July 2019

Junior Member

Thanks Littlefoot!

I think I'll have to do what You just said. I was really wondering if there is any limit of the size of lov or something that caused my issue.

Report message to a moderator

Re: Search field in LOV issue [message #676914 is a reply to message #676913]

Fri, 26 July 2019 07:47

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You're welcome, I hope it'll help.

I don't know whether there's any documented limit; I don't have Forms 6i to check. I guess you've already searched through Forms' Online Help system ...

Report message to a moderator

Previous Topic:	Not able to connect with database from forms 6i but from forms 11g its connecting
Next Topic:	Sending sms to Mobile Phone Using API in Pl Sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 31 12:42:31 CDT 2025