rpcursor = SYS(2015) CREATE CURSOR (rpcursor)(mainkey I, vendor c(100), amt n(10,2), rp l) brows rp_cursor1 = SYS(2015) SELECT op_main_key, op_vendor, op_amt, op_py FROM o_ord_main WHERE op_py = .t. INTO CURSOR (rp_cursor1) brows SCATTER memvar INSERT INTO (rpcursor) FROM memvar SELECT (rpcursor) brows rp_cursor2 = SYS(2015) SELECT p_mainkey, p_vendor, p_amt, p_py FROM sub_payment WHERE p_py = .t. INTO CURSOR (rp_cursor2) brows SCATTER memvar INSERT INTO (rpcursor) FROM memvar SELECT (rpcursor) brows rp_cursor3 = SYS(2015) SELECT r_mainkey, r_vendor, r_payamt, r_py FROM req_payment WHERE r_py = .t. INTO CURSOR (rp_cursor3) browse SCATTER memvar INSERT INTO (rpcursor) FROM memvar SELECT (rpcursor) browsMy problem is when I issue
INSERT INTO (rpcursor) FROM memvarcommand, it only puts zero's into the rpcursor. When I browse rp_cursor1 - rp_cursor3 I do see the information in there. What am I doing wrong here?