Crystal report judgment statement problem

xiaoxiao2021-03-06  111

Stringvar stmp: = '';

IF ({qr_cust_label_pp / .b_low_flow} = 'True') and ({qr_cust_label_pp / .resin} = '5441') THEN STMP: = 'Low Flow';

IF ({qr_cust_label_pp / .b_tg150} = 'True') and (MID ({qr_cust_label_pp / .part_no}, 2, 1) = '5') THEN STMP: = 'TG150';

STMP;

Question: If the second condition is in line; but in the database qr_cust_label_pp / .b_low_flow is a null value; this statement is unforgettable, return or empty! Very strange, I have to modify NULL to false is OK; temporarily record, Try again to think about it ...

转载请注明原文地址:https://www.9cbs.com/read-125125.html

New Post(0)