IF !EOF('inspdata') AND !BOF('inspdata') local lnjobnum lnJobnum=inspheader.jobnum Select max(itemnum) from inspdata where jobnum==lnJobnum into array lnMaxItem RETURN lnMaxItem ELSE Return 0 endif>I seem to be having a new issue with one of my applications.
>IF !EOF('inspdata') AND !BOF('inspdata') > LOCAL lnRecNo > lnRecNo=RECNO('inspdata') > CALCULATE MAX(inspdata.itemnum) FOR inspdata.jobnum=(inspheader.jobnum) TO lnMaxItem && == is not necessary with numbser! > IF lnRecNo>0 > GO lnRecNo IN 'inspdata' > endif > RETURN lnMaxItem >ELSE > RETURN 0 >endif >