How to prime a positional locator

[rjolda]

Hi,
I am passing a value to a lookup table.
Lookup table has a Positional Locator.
What is the process to get the lookup table to the closest match (position) to the passed value?
( Don't want to filter as that will show only matching records and I want the table to show entries AROUND the passed value).
TIA
Ron Jolda
 

[kevin plummer]

Hi Ron,

Try this...

Add these as parameters to your call to the lookup browse. I'm sorting and looking up based on the 2nd column in the browse. You should be able to see the parameters below in your server log window when you sort and locate records in a browse.

'ChartOfAccountsLookupBrowse_Sort' = 2
'_refresh_' = 'locate'
'Locator2chartofaccountslookupbrowse_chartofaccountslookup' = p_web.GSV('P:ChartCode')

[rjolda]

Hi Kevin,
Thanks - I see what you are doing.  Where do you embed this?
Thanks,
Ron

[kevin plummer]

They are all parameters. I insert my browse on a form and when I do that there are template settings to add the parameters..