Want to throw an Error Message on 4th Character

Stivan_dsouza21

While Entering PAN No in Vendor Card, Want to throw an error message when i m Entering the 4th character and it does not match the below caharcters C P H F A T B L J G.

I have written the below code on PAN No. on Validate at table level but the code is not triggering:

IF (STRLEN("P.A.N. No.") = 4 ) THEN
BEGIN

IF NOT ("P.A.N. No." = 'C') OR ("P.A.N. No." = 'P') OR ("P.A.N. No." = 'H') OR ("P.A.N. No." = 'F') OR
("P.A.N. No." = 'A') OR ("P.A.N. No." = 'T') OR ("P.A.N. No." = 'B') OR ("P.A.N. No." = 'L') OR
("P.A.N. No." = 'J') OR ("P.A.N. No." = 'G') THEN
ERROR('PAN No. is not valid');
END;

Can somebody help me out.

mohana_cse06

You can validate this after entering the all value only...not immediatly after entering 4th character..

Stivan_dsouza21

Okies.....
i Need update the Code at table level on validate
right

Stivan_dsouza21

How can i do it

mohana_cse06

Stivan_dsouza21 wrote:

How can i do it

What do you mean by this?

Stivan_dsouza21

Sorry Dude it was not for You

MBerger

I think you are assuming that the validate trigger gets called with each character entered, but it doesn't. Only after you have entered eveything and go away from the field it will get triggered, and i assume that the length of your text is long than 4 characters.

maybe this works better :

if not (copystr("P.A.N. No.",4,1) in ['C', 'P', 'H', 'F', 'A', 'T', 'B', 'L', 'J', 'G']) then
  ERROR('PAN No. is not valid') ;

Stivan_dsouza21

MBerger,

Its Done but only one issue is there when i want to delete the PAN No. then too its showing an error.

mohana_cse06

Write

IF "P.A.N. No." <> '' THEN 
  if not (copystr("P.A.N. No.",4,1) in ['C', 'P', 'H', 'F', 'A', 'T', 'B', 'L', 'J', 'G']) then
    ERROR('PAN No. is not valid') ;

Stivan_dsouza21

Thanks Mberger and Mohana
Its Done.