How to check the field null

shibily

Hi,
Any body know how to check the field in a form ( Not table field ) is blank ?


Thanks in advance

Shibily

rajpatelbca

you can use testfields function to check field in code.
eg.
Record.TESTFIELD(Field, [Value])

Customer.TESTFIELD("No.")

u can set it by using property also.

Notblank of text box.

hope it will help u.

bbrown

IF YourVAR = '' THEN...

Belias

if for "field" you mean something in a texbox, it's not correct.
in a textbox you can insert a field value but also a global variable, a function, a sum of these elements (for example)
so, look at the textbox properties, find sourcexpr property and then test the nullity of whatever you have inserted there

shibily

rajpatelbca wrote:

you can use testfields function to check field in code.
eg.
Record.TESTFIELD(Field, [Value])

Customer.TESTFIELD("No.")

u can set it by using property also.

Notblank of text box.

hope it will help u.

raj
Actually i am using the employee card. I want to validate the Employee.No.. text box

Belias

ah...ok...now it's clear...

employee.testfield("no.");

what's wrong with it?

rajpatelbca

shibily wrote:

raj
Actually i am using the employee card. I want to validate the Employee.No.. text box

try this
testfields("No.")

let me know if it not work.

Belias

we're all posting together...

rajpatelbca

ok Belias solve this problem.

no problem.

shibily

rajpatelbca wrote:

shibily wrote:

raj
Actually i am using the employee card. I want to validate the Employee.No.. text box

try this
testfields("No.")

let me know if it not work.

I tried IF TESTFIELD("No.") then
MESSAGE('Enter anything.!!!');

but. i am getting an error message indicating this is a void expression there must be true false expression.

rajpatelbca

see here is the example of customer you can do this for employee also.


These examples show how to use the TESTFIELD function.

Without Value:

Customer."No." := '';
Customer.TESTFIELD("No.")

This code returns an error message:

You must specify No.in Customer No.=''

rajpatelbca

if you are writing like this
if testfields("No.") then

testfield function will not return value thats why it is giving u an error.
it will raise error message if u do not enter value in it.


the second way.

if employee."no."='' then
message('test');
end;

now is it clear ?

Belias

ok Belias solve this problem.

no problem.

take it easy, I was joking