>>>>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 >