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 May 2, 2024, 11:49 pm This article has been viewed/printed 35120 times. |