Par2: Checking Nulls in MySQL 2007-06-22 -- Geoff Bomford Yeah, have a look at the ODBC tace to see why the Clarion filter works, that
code should be good to use.
I also like to play safe with NULL checks...
BRW1::View:Browse{Prop:SQLFilter} = 'checknumber = 0 and
ifnull(checkprinted,0) = 0'
Should ensure your null check is correct.
Printed April 1, 2025, 11:25 pm This article has been viewed/printed 35399 times. |