I having a problem refreshing data in a mobile application in drop down list controls
A little background so the problem is easier to understand.
I am a volunteer member of the Sun City Sheriff Posse. I volunteered to help them build some web and mobile applications for dispatching and other functions.
I am using AA to build these applications.
One of the services the Posse offers is Vacation Watch; when homeowners (mostly snowbirds) leave thier homes vacant to extended periods, they can request Posse members regularly visit the site and see if there are any issues.
The vacation watch requests are stored in a table. The visits made to the home sites are stored in a child table.
Every couple of weeks, a site visit schedule is created and routes are assigned. This schedule is stored in another table.
I have built a mobile application that user a list control to view the addresses scheduled to be visited.
Since the schedule contains dates for a two week period and also contains a number of "routes" and "vehicles" that may be assigned to the routes, it is necessary to filter the list for each specific users.
To filter the lists the first panel on the application contains two cascading drop down lists.
The first drop down list shows date contained in the schedule table.
The second list shows valid routes for the date selected in the first drop down.
So the user first selects the date for the route and then list two only shows valid routes for that date.
Once these selections are made, a button is enabled that filters the list control, navigates to the next panel displaying the address for that date and route.
Everything works perfect in development.
Now to the problem.
The application is loaded on the mobile device via phone gap and google play developments site.
Everything works well until new records (every two weeks) are added to the schedule table.
The drop down list do not refresh, they will retain the list of records loaded during the last install.
To overcome this problem, I added a "refresh data" button to the first panel BUT that only refreshes the data in the list.
If the drop down control data does not refresh, the new dates (in the new records) are not available.
So, the questions are (1) why do I have to force the list data to refresh, and (2) how do I get drop down lists to refresh?
A little background so the problem is easier to understand.
I am a volunteer member of the Sun City Sheriff Posse. I volunteered to help them build some web and mobile applications for dispatching and other functions.
I am using AA to build these applications.
One of the services the Posse offers is Vacation Watch; when homeowners (mostly snowbirds) leave thier homes vacant to extended periods, they can request Posse members regularly visit the site and see if there are any issues.
The vacation watch requests are stored in a table. The visits made to the home sites are stored in a child table.
Every couple of weeks, a site visit schedule is created and routes are assigned. This schedule is stored in another table.
I have built a mobile application that user a list control to view the addresses scheduled to be visited.
Since the schedule contains dates for a two week period and also contains a number of "routes" and "vehicles" that may be assigned to the routes, it is necessary to filter the list for each specific users.
To filter the lists the first panel on the application contains two cascading drop down lists.
The first drop down list shows date contained in the schedule table.
The second list shows valid routes for the date selected in the first drop down.
So the user first selects the date for the route and then list two only shows valid routes for that date.
Once these selections are made, a button is enabled that filters the list control, navigates to the next panel displaying the address for that date and route.
Everything works perfect in development.
Now to the problem.
The application is loaded on the mobile device via phone gap and google play developments site.
Everything works well until new records (every two weeks) are added to the schedule table.
The drop down list do not refresh, they will retain the list of records loaded during the last install.
To overcome this problem, I added a "refresh data" button to the first panel BUT that only refreshes the data in the list.
If the drop down control data does not refresh, the new dates (in the new records) are not available.
So, the questions are (1) why do I have to force the list data to refresh, and (2) how do I get drop down lists to refresh?
Comment