SELECT Appt_master.Appt_ID, Appt_master.ApptTime1,; Appt_master.ApptTime2, Appt_master.TxRemark, Appt_master.case_no,; Appt_master.pt_name, Appt_master.Sex, Appt_master.ApptRemark,; Appt_master.Ref_ID, Appt_master.Status, Appt_master.Operator,; Appt_master.Clinic; FROM ; appt_master Appt_master; WHERE Appt_master.ApptTime1 BETWEEN ?getDate1 AND ?getDate2; ORDER BY Appt_master.ApptTime1 DBSetProp(ThisView,"View","SendUpdates",.T.) DBSetProp(ThisView,"View","BatchUpdateCount",1) DBSetProp(ThisView,"View","CompareMemo",.T.) DBSetProp(ThisView,"View","FetchAsNeeded",.F.) DBSetProp(ThisView,"View","FetchMemo",.T.) DBSetProp(ThisView,"View","FetchSize",100) DBSetProp(ThisView,"View","MaxRecords",-1) DBSetProp(ThisView,"View","Prepared",.F.) DBSetProp(ThisView,"View","ShareConnection",.F.) DBSetProp(ThisView,"View","AllowSimultaneousFetch",.F.) DBSetProp(ThisView,"View","UpdateType",1) DBSetProp(ThisView,"View","UseMemoSize",255) DBSetProp(ThisView,"View","Tables","appt_master") DBSetProp(ThisView,"View","WhereType",2) DBSetProp(ThisView+".appt_id","Field","DataType","I") DBSetProp(ThisView+".appt_id","Field","UpdateName","appt_master.Appt_ID") DBSetProp(ThisView+".appt_id","Field","KeyField",.T.) DBSetProp(ThisView+".appt_id","Field","Updatable",.F.) DBSetProp(ThisView+".appttime1","Field","DataType","T") DBSetProp(ThisView+".appttime1","Field","UpdateName","appt_master.ApptTime1") DBSetProp(ThisView+".appttime1","Field","KeyField",.F.) DBSetProp(ThisView+".appttime1","Field","Updatable",.T.) DBSetProp(ThisView+".appttime2","Field","DataType","T") DBSetProp(ThisView+".appttime2","Field","UpdateName","appt_master.ApptTime2") DBSetProp(ThisView+".appttime2","Field","KeyField",.F.) DBSetProp(ThisView+".appttime2","Field","Updatable",.T.) DBSetProp(ThisView+".txremark","Field","DataType","C(5)") DBSetProp(ThisView+".txremark","Field","UpdateName","appt_master.TxRemark") DBSetProp(ThisView+".txremark","Field","KeyField",.F.) DBSetProp(ThisView+".txremark","Field","Updatable",.T.) DBSetProp(ThisView+".case_no","Field","DataType","C(6)") DBSetProp(ThisView+".case_no","Field","UpdateName","appt_master.case_no") DBSetProp(ThisView+".case_no","Field","KeyField",.F.) DBSetProp(ThisView+".case_no","Field","Updatable",.T.) DBSetProp(ThisView+".pt_name","Field","DataType","C(6)") DBSetProp(ThisView+".pt_name","Field","UpdateName","appt_master.pt_name") DBSetProp(ThisView+".pt_name","Field","KeyField",.F.) DBSetProp(ThisView+".pt_name","Field","Updatable",.T.) DBSetProp(ThisView+".sex","Field","DataType","I") DBSetProp(ThisView+".sex","Field","UpdateName","appt_master.Sex") DBSetProp(ThisView+".sex","Field","KeyField",.F.) DBSetProp(ThisView+".sex","Field","Updatable",.T.) DBSetProp(ThisView+".apptremark","Field","DataType","C(17)") DBSetProp(ThisView+".apptremark","Field","UpdateName","appt_master.ApptRemark") DBSetProp(ThisView+".apptremark","Field","KeyField",.F.) DBSetProp(ThisView+".apptremark","Field","Updatable",.T.) DBSetProp(ThisView+".ref_id","Field","DataType","I") DBSetProp(ThisView+".ref_id","Field","UpdateName","appt_master.Ref_ID") DBSetProp(ThisView+".ref_id","Field","KeyField",.F.) DBSetProp(ThisView+".ref_id","Field","Updatable",.T.) DBSetProp(ThisView+".status","Field","DataType","I") DBSetProp(ThisView+".status","Field","UpdateName","appt_master.Status") DBSetProp(ThisView+".status","Field","KeyField",.F.) DBSetProp(ThisView+".status","Field","Updatable",.T.) DBSetProp(ThisView+".operator","Field","DataType","C(2)") DBSetProp(ThisView+".operator","Field","UpdateName","appt_master.Operator") DBSetProp(ThisView+".operator","Field","KeyField",.F.) DBSetProp(ThisView+".operator","Field","Updatable",.T.) DBSetProp(ThisView+".clinic","Field","DataType","C(4)") DBSetProp(ThisView+".clinic","Field","UpdateName","appt_master.Clinic") DBSetProp(ThisView+".clinic","Field","KeyField",.F.) DBSetProp(ThisView+".clinic","Field","Updatable",.T.)