FW: How to properly select records

John Esak john at valar.com
Thu May 4 12:08:40 PDT 2006


...]

Remember, text field compares are based on the shorter field.  If
@PM is 11 characters long, it will only compare to the first 11
characters of field 1.

If you want to make sure filePro compares all 20 characters, then
store @PM into a (20,*) field first:

 Then:  xx(20,*) = @pm
   If:  xx eq 1 and aa eq 9 and @pz eq 7
 Then:  select

would

       if: 1 eq doedit(@pm,edit(1),len(1))

work than... and save a variable?

John




More information about the Filepro-list mailing list