>>>SELECT course.coursenumb, course.coursename, ; >>> table2.g1, table2.g2, table2.wm1, table2.g3, table2.tot1, ; >>> table2.g4, table2.g5, table2.wm2, table2.g6, table2.tot2, table2.ltot ; >>> from Course ; >>> inner join TABLE2 on table2.no = course.no ; >>> into cursor csrCourseStats readwrite >>> >>>Thisform.Grid1.RecordSource = "csrCourseStats" >>>>>>i try as
>>LOCAL lbFlUsed >>IF NOT USED("Stud") >> USE Stud IN 0 >> lbFlUsed = .t. >>ENDIF >>SELECT Stud >>APPEND FROM (DBF("csrCourseStats")) >>IF lbFlUsed >> USE IN Stud >>ENDIF >>>
IF NOT USED("Stud") USE Stud IN 0 ENDIF SELECT Stud APPEND FROM DBF("csrCourseStats") USE