NetTalk Central

Author Topic: Locator Type by Date  (Read 4874 times)

osquiabro

  • Hero Member
  • *****
  • Posts: 687
    • View Profile
    • Email
Locator Type by Date
« 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..

osquiabro

  • Hero Member
  • *****
  • Posts: 687
    • View Profile
    • Email
Re: Locator Type by Date
« Reply #1 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