` Checking Nulls in MySQL (Geoff Bomford ) - Icetips Article

Templates, Tools and Utilities for Clarion Developers
	Home Products Download Documentation Demos Support Articles About Buy ALL PRODUCTS Build Automator Checkbox Fixer Icetips Utilities Magic Buttons Magic Entries Magic Locks OutlookBar Power ToolBar Report Previewer SQL Templates TaskPanel Window Fixer XP Theme Xplore GOLD SUBSCRIPTION SILVER SUBSCRIPTION SOLO SUBSCRIPTION Compare Gold/Silver Products Documentation Demos Free SQL Stuff Other Free Stuff PAR2 files Tips & Tricks - NEW Icetips Blog Icetips News Icetips on Facebook Icetips on Twitter Icetips on Youtube All Articles Search articles Top Ten articles Articles by Category Video tutorials What is Clarion? Support Options Live Support Email & Mail Icetips Blog Icetips on Twitter Gold Subscription Silver Subscription Solo Subscription Recurring Subscription Compare Gold & Silver Renew Your Subscription Multiple Copy Pricing

Icetips Article

Back to article list Search Articles Add Comment Printer friendly Direct link

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.

Today is November 21, 2024, 8:11 am
This article has been viewed 35323 times.

Back to article list Search Articles Add Comment Printer friendly

Lost Password

Subscribe

Gold Subscription
Buy Now

Silver Subscription
Buy Now

Solo Subscription
Buy Now

Multiple Copy Pricing

Renew Subscription

Templates, Tools and Utilitiesfor Clarion Developers

Icetips Article

Templates, Tools and Utilities
for Clarion Developers