NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: rjolda on January 24, 2015, 06:43:52 AM

Title: How to prime a positional locator
Post by: rjolda on January 24, 2015, 06:43:52 AM

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
 

Title: Re: How to prime a positional locator
Post by: kevin plummer on January 25, 2015, 03:20:51 PM

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')

Title: Re: How to prime a positional locator
Post by: rjolda on January 25, 2015, 05:51:38 PM

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

Title: Re: How to prime a positional locator
Post by: kevin plummer on January 26, 2015, 01:33:50 AM

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