Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

String manipulation (@left) in a sub-form

Status
Not open for further replies.

deepbhasin

Programmer
Feb 12, 2002
2
US
String manipulation functions (eg @left) works alright in Lotus Notes views, but not in a sub-form.

Why is it that @left does not work in a sub-form & how can I get around it ?

The code used is "FIELD PRINT_ST := @If ((@Left(CB_REF_NO;1)="L");0;1);"

Thanks Deep
 
Prior to using the @left function, @IsValid function was used. This @IsValid function causes the problem. Wonder why ?

The code is as follows
@If(!@IsValid ;@Return(0);"");
FIELD PRINT_ST := @If (@Left(CB_REF_NO ; 1) = "L" ; 0 ;1);
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top