(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › IF NOT and ...  logic
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic IF NOT and ...  logic (Read 888 times)
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
IF NOT and ...  logic
Aug 8th, 2006 at 7:00pm
Print Post Print Post  
I want to make a test that checks to see if a text field is filled and a number field is greater than 0.

This is not working for me:
Code
Select All
IF NOT @IsBlank(VEHICLE_1_DESCRIPTION) and VEHICLE_1_CHARGE > 0


I think the NOT is applying to both sides.  What's the best way to test this?  Nested IF-THENS?
  
**
Captain Infinity
Back to top
WWW WWW  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: IF NOT and ...  logic
Reply #1 - Aug 8th, 2006 at 7:16pm
Print Post Print Post  
The NOT is being applied to both sides as it is not limited to one side. Use Parentheses to let Sesame how to evaluate that conditional.

ex:

Code
Select All
IF ((NOT @IsBlank(VEHICLE_1_DESCRIPTION)) and (VEHICLE_1_CHARGE > 0 ))


-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: IF NOT and ...  logic
Reply #2 - Aug 8th, 2006 at 7:17pm
Print Post Print Post  
Thank you, Ray.
  
**
Captain Infinity
Back to top
WWW WWW  
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