AnsweredAssumed Answered

Find criteria..

Question asked by synergy46 on Mar 9, 2009
Latest reply on Mar 9, 2009 by raybaudi

Title

Find criteria..

Post

Ok.  Here is the deal.

 

Across the top of my form I put 27 buttons:  [A]  [B]  [C]  .... [Z] [All]

 

In ButtonSetup I specify the corresponding letter as a parameter to pass to the script below.  For example, when [J] is pressed I send "J" to the script.

 

Each button acts as a find parameter in this script:

 

Set error capture [on]
sort records // not sure if index does this or not?
enter find mode ()
Set field[Members::LastName;Get(ScriptParameters)]
Perform Find[]
If [Get (LastError<>0]
etc...
endif

 

It works great.... until I get to [J].  In this case, my script finds Johnson, Jones and Follis Jr.

 

(Obviously it is picking up the "J" in "Jr."

 

What I need it to do is to pick off the left(lastname;1) as the parameter.

 

Got any ideas?

 

Thanks in advance.

 

Ron 




Outcomes