TESTFIELD Function

liizz

Hi all,

Is it possible to use the TESTFIELD function in an OR condition.

For e.g:
IF Mode<> 'C' THEN BEGIN
IF (NOT ((Number='')) OR (Comments='')) OR
(NOT ((Comments='')) OR ("Number"='')) THEN
ERROR('Either Number or Comments should be filled');
END;

I want to validate if either the field Number or Comments have been input.

Thanks

Liizz

mohana_cse06

Did you try

IF ((Number = '') AND (Comments = '')) THEN
  ERROR('Either Number or Comments should be filled');

liizz

Mohana,

The condition is an OR one.

I have tried it before with an OR, and it is verifying if both conditions are being satisfied.

Liizz

mohana_cse06

You want to show error message when both fields are blank,right?

if yes, use my code..

manisharma31

mohana code should work for you.
The condition is to check both the values are not blank.

mohana_cse06

manisharma31 wrote:

mohana code should work for you.
The condition is to check both the values are not blank.

Read the initial post carefully

liizz wrote:

I want to validate if either the field Number or Comments have been input.

liizz

Yes, ok.

I got you.. Sorry its my mistake.

We are checking only if both fields are blank.

Thanks
Liizz