>>SELECT * from regtrans ; >> WHERE regtrans.trans_date >= Thisform.cntDates.txtFrom.Value AND ; >> regtrans.trans_date <= Thisform.cntDates.txtTo.Value ; >> UNION ; >>SELECT * from tranhist ; >> WHERE tranhist.trans_date >= Thisform.cntDates.txtFrom.Value AND ; >> tranhist.trans_date <= Thisform.cntDates.txtTo.Value ; >> INTO CURSOR csrTotalTran ORDER BY trans_date, trans_time >>>>
CREATE CURSOR crsTest1 (Fld1 I) CREATE CURSOR crsTest2 (Fld1 I) FOR asd = 1 TO 20 INSERT INTO crsTest1 VALUES(asd) NEXT FOR asd = 21 TO 50 INSERT INTO crsTest2 VALUES(asd) NEXT SELECT * FROM CrsTest1; WHERE Fld1%3 = 0; UNION; SELECT * FROM CrsTest2; WHERE Fld1%2 = 0; INTO CURSOR ccc; ORDER BY Fld1 BROWSE NORMALVFP9 SP1