FormA, displays data in tableview (locked) format based on below query :
- Code: Select all
foundset.loadRecords('select id from orderdetails where emp_id=? and jobStatus= ? ',[varEmpId,'OPEN'])
for each row of table has stop button which indicates once hit STOP button jobStatus would be changed to CLOSE for that row in DB table and pop-ups form FormB in modal dialog window which consist of text fields and a save button, so that remaining information is entered. Once hits save button in FormB. Does two task: 1. Updates information for that row in DB table and 2. Show the same form FormA. which displays all data where jobstatus='OPEN'.
In FormA onShow event I am loading foundset to display data in table format.
how to close modal dialog for FormB and then reload or reshow back the same form FormA with all the data where jobStatus = ' OPEN' , so that I can get exact result.
I hope I explained it properly...