SELECT 0 USE AuditCls APPEND BLANK replace userid WITH gcNovellId, sdate WITH DATETIME(), numRec WITH nTltRecs,ieflag WITH "I" USEI suggest
insert into AuditCls (userid, sdate, numRec, ieflag) values (gcNovellId, datetime(), nTltRecs, "I")The insert code replaces many lines of code, and is usually faster.
> > SELECT 0 > USE AuditCls > APPEND BLANK > replace userid WITH gcNovellId, sdate WITH DATETIME(), numRec WITH nTltRecs,ieflag WITH "I" > USE > >**and the TXTLASTIMPORTDATE textbox Init event in myform.scx : > >LOCAL lcLastImportDate,lctestdate > >SELECT TOP 1 Sdate,userid ; > FROM AuditCls ; > GROUP BY 1 ; > ORDER BY 1 DESC WHERE IEFLAG = "I" ; > INTO CURSOR top1 > >SELECT top1 > >lcLastImportDate = sdate > >lcLastImportDate = TRANSFORM(lcLastImportDate,'@YL') +' by '+userid > >thisform.TXTLASTIMPORTDATE.Value=lcLastImportDate > >Thisform.txtLastImportDate.Refresh() > >>