Contact Info Tel: 916.726.5675
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
Paradox To/From
To/FromCODEGuides
Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:
   ► MB Lobby ► Corel Paradox / ObjectPAL Coding Board ► Paradox Reports Topic   Print This     

blank in calculated field

blank in calculated field in Paradox Reports topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: calculated   blank calculated   blank calculated field  
 blank in calculated field Post ID #14042, 1 reply 4/12/2010 4:20:18 PM  
jglumb
Farmington Hills, MI USA

Is it possible to check for a null (blank) value from within a calculated field. I currently have a calculated field using an iif statement that checks to see if the value of the field is 0 then it returns a string on the report. I would like to also check if the field is blank and return a different string on the report. 
 Posted 16 years ago (Thread Starter)
Comment Quote
About jglumb
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Post ID #14042, 1 replies
Thread Started 4/12/2010 4:20:18 PM
View Counter=3016
Last Reply Posted 5/14/2010 10:43:34 AM)
Location=Farmington Hills, MI USA 
Joined=23 years ago   MB Posts=1  
Most Recent Post
 RE: blank in calculated field 5/14/2010 10:36:41 AM  
AIBreveleri

1. Turn off "Treat Blanks as Zeros".  Interactively, pick Edit | Preferences | Database and uncheck "Treat blank fields as zeros".  In code, use

session.blankAsZero(false)

2. Use this model for your statement.

iif(isblank(TT.FF]),"this field is blank",iif([TT.FF]=0,"this field is zero","this field contains "+string([TT.FF])))

-Al.
 Posted 16 years ago
Comment Quote
About AIBreveleri
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Post ID #14096 (Level 1.1)  Reply to 14042
Thread Started 5/14/2010 10:36:41 AM
Location= 
Joined=25 years ago   MB Posts=286   KB Comments=8  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1213A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14042 Counter
3016
Since 4/12/2010
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com
LEGACY DATA:
(from PrestwoodBoards.com)
CONTACT US:
Office Hours: 8am-5pm | Mon thru Fri 
916-726-5675 (office)
8421 Auburn Blvd, STE 256
Citrus Heights, CA 95610


©1995-2026 Prestwood IT Solutions.   [Security & Privacy]  

 
↑