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 October 24, 2026, 1:53 pm This article has been viewed/printed 36253 times. |