(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Finding a negative value
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Finding a negative value (Read 326 times)
Blair Wettlaufer
Junior Member
Members
**
Offline


No personal text

Posts: 98
Location: Hamilton, ON
Joined: Jun 4th, 2005
Finding a negative value
Oct 27th, 2005 at 8:23pm
Print Post Print Post  
Hi all!

Another quick question ... if want to write a programming line to check to see if a client has previously had an NSF cheque with me.  I can xlookupall their Payments, but how would I check to see if any of those payments are <0 ?

Thanks!
Blair
  
Coesper erat: tunc lubriciles altravia circum&&Urgebant gyros gimbiculosque tophi:&&Moestenui visae borogovides ire meatu:&&Et profugi gemitus exgrabuere rathae
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Finding a negative value
Reply #1 - Oct 27th, 2005 at 8:35pm
Print Post Print Post  
After you have your list of values, loop through all of them. Access an individual value with @AccessStringArray, convert it to numeric with @ToNumber and use an "if" statement to see if result is less than zero.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
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