| smart lov [message #463204] |
Wed, 30 June 2010 03:52  |
narang79
Messages: 137
Registered: June 2010
|
Senior Member |
|
|
i want smart lov search like
i type m then show all like 'm' if type mo then show like 'mo'
we use timer & execute query for this smart serach
but for very heavy data it will take more time
how can we fast this query or
this there qny other option for this option
|
|
|
|
| Re: smart lov [message #463205 is a reply to message #463204] |
Wed, 30 June 2010 03:57  |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
narang79 wrote on Wed, 30 June 2010 09:52i want smart lov search like
i type m then show all like 'm' if type mo then show like 'mo'
LOVs do this by default.
narang79 wrote on Wed, 30 June 2010 09:52
we use timer & execute query for this smart serach
Why?
What exactly are you actually doing?
narang79 wrote on Wed, 30 June 2010 09:52
how can we fast this query or
this there qny other option for this option
You'd have to tell us what you're actually doing and what the query actually is before we could possibly make suggestions.
|
|
|
|
| Re: smart lov [message #463228 is a reply to message #463205] |
Wed, 30 June 2010 05:19 |
narang79
Messages: 137
Registered: June 2010
|
Senior Member |
|
|
sir a button shown in a form
when we press button the lov open & we select any record from lov like ma & press enter then
according to lov data coming in new block through execute query
but i want
when lov open select item name like 'm' then don't use enter query execute auto & data shown in new block according to m
after that m i select o means select mo then data shown in new block like mo
|
|
|
|
| Re: smart lov [message #463233 is a reply to message #463228] |
Wed, 30 June 2010 05:32 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
|
I really would give up on that plan - it's going to be really difficult to code and it's going to be horribly slow.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: smart lov [message #465464 is a reply to message #465437] |
Wed, 14 July 2010 04:47 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
@David - OP appears to want the actual datablock to be populated based on what is entered as it is entered.
So user types M - query is issued to get everything that starts with M.
User then types O - query is again issued to get everything that starts with MO.
|
|
|
|
|
|
|
|
|
|
| Re: smart lov [message #466644 is a reply to message #466631] |
Tue, 20 July 2010 07:23 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
David I think you're missing the point.
The OP wants to mimic an LOVs filtering functionality in a datablock.
So requery data everytime they type a letter.
|
|
|
|
| Re: smart lov [message #466647 is a reply to message #466644] |
Tue, 20 July 2010 07:25 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I am not missing the point. The point is that what the user wants sucks in terms of performance, that's why there are long LOVs.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
