Wednesday, 18 December 2013

Refresh(),reread(),research(),executequery() in ax 2009

Refresh(): It basically just refreshes the screen with whatever is stored in the form cache.

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 data source, 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.

No comments:

Post a Comment