>SELECT docudeck > APPEND BLANK > REPLACE docu_id with maxvalue > REPLACE file_name with ALLTRIM(finame) > REPLACE file_loc with ALLTRIM(mfile) > Replace no_pages with val(regpagesscan) > REPLACE scanby with ALLTRIM(guser) > REPLACE docindex_i with docindex.docindex_i > REPLACE proj_no with alltrim(Upper(thisform.text1.value)) > REPLACE workpkg_no with alltrim(Upper(thisform.text2.value)) > REPLACE created_dt with date() > = TABLEUPDATE(.T.,.T.) >>
Insert into docudeck (docu_id, file_name, file_loc, no_pages, scanby, docindex, proj_no, workpkg_no, created_dt); values (maxvalue, alltrim(finame), alltrim(mfile), val(regpagesscan), alltrim(guser), docindex.docindex_i,; alltrim(Upper(thisform.text2.value)), alltrim(Upper(thisform.text1.value)), date())