Which code do you use?

To centralize some of your processing, you decide to write PUSQL library modules that contain procedures that can be called from form triggers or menu items. You need to populate some fields based on values in other fields.
Which code do you use?

To centralize some of your processing, you decide to write PUSQL library modules that contain procedures that can be called from form triggers or menu items. You need to populate some fields based on values in other fields.
Which code do you use?

A.
IF FIND ITEM I ‘ORDERS. order total’ I > 10000
THEN
FIND_ITEM(‘ORDERS.large order’)’ := ‘Y’;
MESSAGE ( ‘WARNING – large order!);
END IF;

B.
IF :ORDERS.order total > 10000
THEN
:ORDERS.large order := ‘Y’;
MESSAGE (‘ WARNING – large order! ");
END IF;

C.
IF ‘ORDERS. Order_total’ > 10000
THEN
‘ORDERS .large_order’ :=’Y’ ;
MESSAGE ( ‘WARNING – large order!’);
END IF;

D.
IF :ORDERS.order_total> 10000
THEN
COPY ( ‘ORDERS . large_order’, ‘Y’ ) ;
MESSAGE ( ‘WARNING – large order! ‘);
END IF;

E.
IF NAME_IN ( ‘ORDERS. Order_total’ ) > 10000
THEN
COPY ( ‘Y’ , ‘ORDERS .large_order’ ) ;
MESSAGE (‘WARNING – large order! ‘);
END IF;



Leave a Reply 0

Your email address will not be published. Required fields are marked *