` Comment on an Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Add a comment to an Icetips Article

Please add your comments to this article. Please note that you must provide both a name and a valid email address in order for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!

Your Name:  
Email:  
Header text/Subject:  

Please enter your comment in the box below:
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 May 3, 2024, 3:33 am
This article has been viewed 35121 times.


Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password:


Gold Subscription
Buy Now
Silver Subscription
Buy Now
Solo Subscription
Buy Now
Multiple Copy Pricing
Renew Subscription