offline dropdowns with online data - RDMLX
Posted: Sat Dec 07, 2013 6:42 am
One of the best uses for the new offline capabilities is to "cache" relatively static table data, for dropdowns and other possible validations or display functionality, as offline tables. I have modified the LREX0301(Download Data) and LREX0310 (Working Offline and Online) to demonstrate this functionality. the schema has an additional offline table named "Departments" and the "Employee" table has a new column name "Department". I download the department data from DEPTAB only once and use the offline Departments table to populate a dropdown whether I am working offline or online. Even if you don't expect to work offline, this will improve overall performance, reducing the i/o between the device and the server. I have attached a sample new schema along with the modified code for the forms.