(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Blank field question
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Blank field question (Read 711 times)
FlipGilbert
Full Member
***
Offline


Running Ver 2.6.4

Posts: 236
Location: Sandy Eggo
Joined: Mar 8th, 2005
Blank field question
May 27th, 2005 at 10:12pm
Print Post Print Post  
Hello All
I have a program that looks up a mileage charge for the customer, my problem is that it recognizes $0.00 as a blank field. I only want it to lookup if the field is blank, $0.00 might be put in the field as a figure.

Here is the program

if mileage charge = {""} then {
     XLOOKUP("data\newdispatch.db", company name, "cust!cust_name", "mileage charge", mileage charge)
}

I only used the {} after the equal to show the quote symbols
thank you for any help
  
It's not what a man says that matters or how he says it, but what he does and how he does it.
Back to top
 
IP Logged
 
pineberry
Full Member
***
Offline


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
Re: Blank field question
Reply #1 - May 27th, 2005 at 10:28pm
Print Post Print Post  
Have you tried
if @IsBlank
Pg 183 of programming guide

Harley
  
Back to top
 
IP Logged
 
FlipGilbert
Full Member
***
Offline


Running Ver 2.6.4

Posts: 236
Location: Sandy Eggo
Joined: Mar 8th, 2005
Re: Blank field question
Reply #2 - May 27th, 2005 at 11:01pm
Print Post Print Post  
thank you for your help Harley, works just as advertised. thanks too for the pg number.
  
It's not what a man says that matters or how he says it, but what he does and how he does it.
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge