>What is a best way to update tables from my cursor,
>I want to update my examtran table form cursor new
>>
>texamcode=thisform.code.Value
>tscode=thisform.scode.value
> tlcode=thisform.lcode.value
> tsec=thisform.sec.value
> SELECT Student.code as zcode, Student.descr as zname,;
> Student.fname, Student.sex, Student.sec, Student.lcode, Student.scode,;
> Student.broll, Student.path,Student.weight,;
> Exam.code as examcode, Exam.descr, Exam.fmdate, Exam.year, Exam.change1, Exam.sno,;
> Exam.nmonth, Exam.bex, Exam.begdate;
> FROM student,;
> exam;
> WHERE exam.code=m.texamcode.and.student.scode=m.tscode;
> .and. student.lcode=thisform.lcode.value.and.student.sec=thisform.sec.value.and.student.admtd=1;
> INTO CURSOR new<>
You may want to use UPDATE FROM, as shown in
Re: UPDATE FROM syntax Thread #
1134219 Message #
1134231
If it's not broken, fix it until it is.
My Blog