Re: Refresh tableframe - source queryHello Steve..., , Thank you for all your input. I have solved my problem. I changed the source of my table frame from a query to a table., , I then used ui.ForceRefresh() to refresh the table frame when new data is entered in the table. From what I was doing, ForceRefresh() does not work when table frame is source by a query., , See below..., , if not ui.attach(tblCalOsha) then , msgStop("Alert", "Tableframe TblCalOsha failed to attach!"), return, endif, , ui.forceRefresh(), ui.dropGenFilter(), ui.MoveToRecNo(1), , As so far for the below code...It is how all of my reports and tables frames are filtered with my existing database. The original programmer is no longer around for comment. See below code..., , method pushButton(var eventInfo Event), , var, dyn DynArray[] AnyType, endVar, , if not isblank(fldEmpno) then, dyn["empno"] = CHR(34) + fldEmpno + CHR(34), else, endIf, , ui.setGenFilter(Dyn), , endmethod, , Thank you for the suggestion Steve, I will experiment with... |