filepro quirk

[Kenneth Brody]

Fairlight wrote:
[... COMPARE() ...]
> I do note that the docs I just looked at said "with case sensitivity".
> They don't go on to elaborate on whether the string lengths matter.  Based
> on the trinary nature of the return value, however, it looks like it works
> much like perl's "cmp" operand, and should actually give the desired
> results.

What do your tests show?  What does COMPARE("TX","TXA") return?

> Thanks for the clue, Jeff.  I'll try and actually remember it this time
> around.  I now remember even more of the conversation, since it got into
> not being able to use it as a test value in an If: line--I believe Ken said
> only functions that returned boolean values could be used directly in that
> fashion.  Compare not being a boolean function, it requires an extra line
> of code, I believe--assuming I'm remembering the rest of what we talked
> about before correctly.

It doesn't take an extra line.  It just means that instead of:

    If:  compare(field1,field2)

you need:

    If:  compare(field1,field2) = "0"

(Assuming you are comparing for equality only.)

[...]

-- 
+-------------------------+--------------------+-----------------------------+
| Kenneth J. Brody        | www.hvcomputer.com |                             |
| kenbrody/at\spamcop.net | www.fptech.com     | #include <std_disclaimer.h> |
+-------------------------+--------------------+-----------------------------+
Don't e-mail me at: <mailto:ThisIsASpamTrap at gmail.com>