Interested to Buy Any Domain ? << Click Here >> for more details...
i want run following code on button click of view. i am
trying to retrieve data from isc_order_details table and
isc_product table. but after retriaval of data i m getting
error like FIELD MUST BE ENTERED!!
DECLARE
m number;
n number;
CURSOR order_details IS
SELECT PRODUCT_ORDER_QUAN,PRODUCT_ID FROM
isc_order_details WHERE order_id=:isc_order_master.order_id;
amount NUMBER (8,2):=0.0;
alert number;
BEGIN
go_block('isc_order_details');
first_record;
m:=:system.cursor_record;
last_record;
n:=:system.cursor_record;
OPEN order_details;
--for i in m..n
loop
FETCH order_details
INTO :ISC_ORDER_DETAILS.PRODUCT_ORDER_QUAN,:ISC_ORDER_DETAIL
S.PRODUCT_ID;
IF order_details%FOUND THEN
SELECT order_value,order_date
INTO :ISC_ORDER_MASTER.ORDER_VALUE,:ISC_ORDER_MASTER.ORDER_D
ATE
FROM isc_order_master WHERE
order_id=:ISC_ORDER_MASTER.ORDER_ID;
SELECT product_desc,product_price
INTO :ISC_ORDER_DETAILS.PRODUCT_DESC,:ISC_ORDER_DETAILS.PROD
UCT_PRICE
FROM isc_product WHERE
product_id=:ISC_ORDER_DETAILS.PRODUCT_ID;
next_record;
END IF;
EXIT WHEN order_details%NOTFOUND;
END LOOP;
last_record;
CLOSE order_details;
EXCEPTION
when NO_DATA_FOUND then
alert:=SHOW_ALERT('ENTER_DATA');
Go_Item('isc_order_master.order_id');
END;
- 0 Answers
- 2178 Views
- Zensar, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Devise a program to implement the Fibonacci sequence.
how to test the orientation of the layout in android.to note any changes in the ui design when change orientation
can any one give me code to keyed a flat file and used chain in RPGLE to search any item
find out the list of users who have access to all t-codes starts with 'SU'? thanks in advance all.
Write a program in prolog to compute the factorial of a number using iteration/tail recursion?
Write a Program for matrix multiplication.
1.Why does only one copy of a servlet object get created? What happens if you want to remove an old servlet object currently running but do not want to stop the entire servlet engine? 2.How does one servlet object deal with interactions from many browser? (e.g. if your servlet ran an email site, how can it keep track of hundreds of users logging in, reading their mail, etc.)
how to write test case for a text field that should be mandatory
Write code to add functions, which would work as get and put properties of a class?
utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts
Write a code snippet to display an integer in a binary format?
Hello, Can anyone tell me the source code for FLAMES game in Control Language Programming(CLP)of AS/400.
C Code 
