employed_since = get_property(@WINDOW:".DATE","TEXT") IF LEN(employed_since) = 0 THEN msg("Please enter a date for 'Employed Since' to proceed") RETURN END theSelect = "" theSelect<-1> = 'SELECT EMPLOYEE' theSelect<-1> = 'SELECT EMPLOYEE WITH EMPLOYMENT_DATE GE ':quote(employed_since) theSelect<-1> = 'SELECT EMPLOYEE WITH TAX_FILE_NUMBER AND WITH TFN_AUTHORITY' // theSelect<-1> = 'SELECT EMPLOYEE theSelect<-1> = 'SELECT EMPLOYEE BY EMPLOYMENT_DATE' Params = 1 Params<2> = 0 Params<3> = "Selecting EMPLOYEES data for period: " Params<4> = 1 numshifts = process_select_statement_func(theselect, params, 0) Popup_Rec = '' Popup_Rec = -1 Popup_Rec = -1 Popup_Rec = -1 Popup_Rec = -1 Popup_Rec = 16777215 Popup_Rec = 'Tahoma':@SVM:'-11':@SVM:'400':@SVM:'0':@SVM:'0':@SVM:'5':@SVM:'0':@SVM:'39':@SVM:'0':@SVM:'0':@SVM:'0':@SVM:'0':@SVM:'11':@SVM:'2':@SVM:'0':@SVM:'21' Popup_Rec = 'EMPLOYEE' DisplayText = '' Popup_Rec = DisplayText text = 'EMPLOYEE' :@SVM:'10':@SVM:'C':@SVM:'C':@SVM:'':@SVM:'id' text := @VM:'FULL_NAME' :@SVM:'20':@SVM:'L':@SVM:'C':@SVM:'':@SVM:'Full Name' text := @Vm:'EMPLOYMENT_DATE' :@SVM:'11':@SVM:'C':@SVM:'C':@SVM:'[IODATE]':@SVM:'Date Employed' text := @Vm:'TERM_FLAG' :@SVM: '3':@SVM:'C':@SVM:'C':@SVM:'B':@SVM:'Term' text := @Vm:'TFN_AUTHORITY' :@SVM: '3':@SVM:'C':@SVM:'C':@SVM:'B':@SVM:'Auth.' text := @Vm:'TAX_FILE_NUMBER' :@SVM:'20':@SVM:'C':@SVM:'C':@SVM:'':@SVM:'Tax File Num' Popup_Rec = text Popup_Rec = 'T' Popup_Rec = 2 Popup_Rec = 'Employee TFN Declaration' Popup_Rec = Null$ // Popup_Rec = "F" Popup_Rec = "E" ; // Return value: K{ey}/DocID, R{ead only}, Row P{ositions}, Popup F{ield} (ie. Column), Table C{olumn} (ie. Field), E{ntire} Row Popup_Rec = 1 Popup_Rec = 1 Popup_Rec = 1 Popup_Rec = 1 Popup_Rec = 1 Popup_Rec = 1 Popup_Rec = 1 Popup_Rec = 1 Popup_Rec = 0 Popup_Rec = 1 Popup_Rec = 0 Popup_Rec = 0 Popup_Rec = 1 Popup_Rec = 0 Popup_Rec = 0 Popup_Rec = 1 Popup_Rec = 16245453 Popup_Rec = 16245453 retval = Popup(@Window, Popup_Rec, '') /* * */ Employee_Table$ = @WINDOW:".TABLE" items = DCOUNT(retval, @FM) void = set_property(employee_table$, "ARRAY", "") ; // clear whole array FOR i = 1 TO items rowinfo = retval Stat = Send_Message(Employee_Table$, "INSERT",i, RowInfo) NEXT i