Hey buddy ,
Im curious abt cursors.. Is there a way to reset(or flush) the cursors so that it can be used for a new update. I have different folders, all with "tlog.dbf" tables. I'm trying to import data frm all these tables into one Mysql "tlog" table(basically updating). I ran ur piece of code and it worked fine.But when I tried to update the Mysql tlog table using a different "tlog.dbf" table, it just wrote the same data that was placed previously into cursor crsTest..
SELECT PK, tempt FROM tlog;
into CURSOR crsTest
SQLPREPARE(lccon, [UPDATE mytab SET tdtime=?crsTest.TempT WHERE mytab.PK = ?crsTest.PK])
SELECT crsTest
SCAN
SQLEXEC(lccon)
ENDSCAN