>SELECT " " as is_sel,contract, vendor,; > mjclass ,; > mjunclass,; > mjcontnet,; > forclass,; > forunclass ,; > forcontnet,; > fornetcost,; > forsupmtl ,; > forother ,; > bondamt ,; > forexwk ; > FROM contract; > WHERE org=orgfltr; > INTO CURSOR delay1 READWRITE ORDER BY contract NOFILTER > > >CREATE cursor c_group ; >(is_sel C(2), contract c(13), vendor c(12), ; > mjclass N(13,2),; > mjunclass N(13,2),; > mjcontnet N(13,2),; > forclass N(13,2),; > forunclass N(13,2),; > forcontnet N(13,2),; > fornetcost N(13,2),; > forsupmtl N(13,2),; > forother N(13,2),; > bondamt N(13,2),; > forexwk N(13,2),; >MJNETCST n(13,2),title C(65),title1 c(30),title2 c(30),title3 c(30)) > > >SELECT c_group >*********************************** >APPEND FROM DBF("delay1") >>Append fails at this point and doesn't populate c_group
>SCAN > SCATTER MEMO memv > INSERT INTO c_group FROM MEMVAR >ENDSCANWhich VFP version you're using, once again?
insert into c_group select " " as is_sel,contract, vendor,; > mjclass ,; > mjunclass,; > mjcontnet,; > forclass,; > forunclass ,; > forcontnet,; > fornetcost,; > forsupmtl ,; > forother ,; > bondamt ,; > forexwk ; > FROM contract; > WHERE org=orgfltr