Hi.. refresh() will not reread the record from the database. It basically just refreshes the screen with whatever is stored in the form cache.
refreshEx() will refresh the view of the records. reread() will only re-read the CURRENT record from the DB so you should not use it to refresh the form data if you have added/removed records. It's often used if you change some values in the current record in some code, and commit them to the database using .update() on the table, instead of through the form datasource. In this case .reread() will make those changes appear on the form. research() will rerun the existing form query against the datasource, therefore updating the list with new/removed records as well as updating existing ones. This will honour any existing filters and sorting on the form. executeQuery() is another useful one. It should be used if you have modified the query in your code and need to refresh the form. It's like .research() except it takes query changes into account. Hope your queries have been answered. I am not sure about the combination of using table.reread followed by datasource.refresh. If you have any other thoughts, kindly share it across. Regards, Anitha On Fri, May 29, 2009 at 10:13 AM, anton_tjiptadi <anton_tjipt...@yahoo.com>wrote: > > > Hi all, > > What is the different between [table].reread and [datasaource].reread ? > > I have a problem with my Ax3, seems this reread function not working > correctly bcos sometimes return the correct value (the new updated record) > but sometime return old value. > > FYI, bfore using the Reread function, I update or write first the record. I > run few times, but often after Reread what I already > "write" on that table is lost. > > For more detail may I ask what Ax exactly doing with below function : > [table].reread > [datasource].reread > [datasource].refresh > [datasource].refreshEx > [datasource].research > [datasource].executeQuery > > furthermore can I use it in combination for example after [table].reread > then [datasource].refresh ? > > Thanks in advance, > Anton > > >
