Normal Topic Searching for highest value in another file. (Read 378 times)
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Searching for highest value in another file.
Dec 11th, 2015 at 8:42pm
Print Post Print Post  
I have an application that looks for data in another file's element called CodeNo.  I'm currently using a @xlu statement to get data based on the value I enter into an element (call it CheckerElement) on my main form.  It works great but I'm concerned about someone entering in a number in CheckerElement that doesn't exist in CodeNo.

I'm trying to manipulate my application performance based on the presence of a CodeNo in the other file.  CodeNo is a number and I want to make sure a number I add in an element in my main file is present in my other file.

Is there an easy way to check if a CodeNo is present in the other file?  For example, if the CodeNo element includes 1,2,3,4,5,6 and I enter 22 in CheckerElement, what does the @xlu statement return?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Searching for highest value in another file.
Reply #1 - Dec 14th, 2015 at 8:58pm
Print Post Print Post  
NHUser wrote on Dec 11th, 2015 at 8:42pm:
Is there an easy way to check if a CodeNo is present in the other file?  For example, if the CodeNo element includes 1,2,3,4,5,6 and I enter 22 in CheckerElement, what does the @xlu statement return?



@XLU would return a blank value and set @Error to be TRUE.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged