Filter Defaults

[broche]

NT 8.23
CL 9.0

Am I corretc in the following:

If a filter has been defined on a browse and it fails then all the records will be displayed?

Brian.

[kevin plummer]

yes if it is "invalid". I'm not sure what you mean by fails.

[broche]

Yes - Invalid is a better word.
If the Filter is invalid I want to make sure that no records show - is this possible.

Thanks.

[Bruce]

no it's not possible. The filter is processed by the clarion View engine - which usually passes it on to the back-end. What you get back is what you get back.

cheers
Bruce

[Poul]

on many of my nettalk browses  i have used

 

Code: [Select]

if loc:FilterWas and EVALUATE( loc:FilterWas) = ''
    ThisView{prop:Filter} = '1=3'
     packetdebugme.append('<tr><13,10><td>' &  'Invalid Search Criteria '  & loc:FilterWas &'</td></tr>'& P_web.CRLF)
    do AddPacket
  end
after "setview"  embed - works for SQL, i have not tried anywhere else ...

[Bruce]

yes, I can see this would likely do the trick, and the processing cost is minimal.