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 November 21, 2024, 6:38 am This article has been viewed/printed 35322 times. |