Locator Problem with MSSQL

[johanco123]

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

[Rene Simons]

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

[Bruce]

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