NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: osquiabro on August 30, 2019, 02:53:39 PM

Title: Locator Type by Date
Post by: osquiabro on August 30, 2019, 02:53:39 PM

I tried to use the locator type with a date field but it does not work, when searching for the trace a correct query date is generated> = locator type but the locator does not move to the record

NT 10.38 with SQL

thanks..

Title: Re: Locator Type by Date
Post by: osquiabro on August 31, 2019, 06:21:06 AM

Resolved..

IF clip(loc:LocatorValue) <> ''
    IF Loc:LocateOnFields='Eve2:Fecha_DATE'               
        loc:FilterWas = 'SQL(dbo.DateOnly(A.Fecha) =<39>'& format(DEFORMAT(Loc:LocatorValue,@d8),@d10-) &'<39>  )'
        ThisView{prop:Filter} = loc:FilterWas           
        loc:viewoptions = bor(loc:viewoptions, Net:NoFilter)
    END   
END