NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: johanco123 on March 13, 2014, 11:46:54 PM

Title: Locator Problem with MSSQL
Post by: johanco123 on March 13, 2014, 11:46:54 PM

Hi Bruce
NT7.35. I have a filter with the following code, the filter works 100% but the locator does not work now on any column.

 loc:FilterWas = clip(l:Filter2) &' and SQL(B_BrokerGroup = ' & p_web.GSV('SV_BrokerGroupNo') & ')'
ThisView{prop:Filter} = loc:FilterWas
Loc:LocatorValue = p_web.GetLocatorValue(Loc:LocatorType,'WBrowsePolicies',Net:Both)
p_web.Trace(loc:FilterWas)

Any suggestions how I can get the locator working

Regards
Johan

Title: Re: Locator Problem with MSSQL
Post by: Rene Simons on March 14, 2014, 03:20:39 PM

Hi Johan,

Can you show what the Loc:Filterwas actually looks like once you have assigned the value to it?
When the filter is not formulater properly, It simply won't work.

Cheers Rene

Title: Re: Locator Problem with MSSQL
Post by: Bruce on March 16, 2014, 11:31:39 PM

Hi Johan,

locator code changed in 7.36 and 7.37, so definitely worth updating.

for debugging purposes you can inspect the filter (using debugview, and the template options to send the filter to debugview) to see how the locator is being applied.

Cheers
Bruce