Quote:
Originally Posted by andrewst
I'm not quite following (again!). My code would be something like this pseudo-code:
Code:
IF (cart is not empty) THEN
v_order_no := <get next order no>;
insert into orders (order_no, order_date) values (v_order_no, <today's date>);
FOR each item in cart
insert into order_lines (order_no, line_no, item_no, quantity)
values (v_order_no, <cart item line no>, <cart item item no>, <cart item quantity>);
END FOR
END IF
... if you see what I mean?
No, I just forgot to put it in! |
Hey There. ONCE AGAIN, I failed to deliver what I wanted and ONCE AGAIN you sorted it out for me. Thank you very much and your pseudocode is just what I also had in mind, just that I delivered it wrong. Thanks for your help. =)
Happy new Year.