There is a choice of workflows. Generally, your app has a local (client-side) copy of a subset of data from a DB. Just updating the DB doesn't automatically update the local copy.
1) update the local copy and push changes to the DB 2) update the DB and pull a new local copy 3) Use something that automatically does one of the above. I don't know if Zend does (3) or not. -Alex On 3/25/14 10:00 AM, "SmileySnr" <[email protected]> wrote: > down vote favorite > > >My environment w7,wamp 2.4, flashbuilder 4.6, apacheflex 4.12. > >I have the following base table sets in the DB. > > Lecturers(lecturerID,name, email) > Students(studentID, name, email) > ULMs(ulmid,name, marksAvailable, lecturerID) > ModuleNames(modulenameID, name, lecturerID) > StudentModules(studentmoduleID,ModuleID) > >StudentProgress(studentprogressID,studentID,moduleID,ulmID,marksAwarded, >lecturerID) > ModuleContents(moduleID,ulmid) > >These tables would be a bit ugly and meaningless to display, instead I >created a set of views... > > ulmview (ulmID,ulmname,lecturerID,ulmname,marksAvaialble) > mnview (modulenameID, modulename, lecturerID, lecturername) > mcview (modulenameID, modulename, ulmid, ulmname) > smview (studentID, studentname, moduleID, modulename) > spview (studentprogressID,studentID, studentname, moduleID, >modulename, >ulmID, ulmnmae, lecturerID, lecturername, marksAwarded) > >Displaying , adding, updating and deleteing entries in the base tables >work >great. Although I can verify that the actual database has changed, the >display has not reflected this. If I refresh the browser display (F5), ie >reload the url, the data is now displayed. > >AS3 function to add a new record > > down vote favorite > > >My environment w7,wamp 2.4, flashbuilder 4.6, apacheflex 4.12. > >I have the following base table sets in the DB. > > Lecturers(lecturerID,name, email) > Students(studentID, name, email) > ULMs(ulmid,name, marksAvailable, lecturerID) > ModuleNames(modulenameID, name, lecturerID) > StudentModules(studentmoduleID,ModuleID) > >StudentProgress(studentprogressID,studentID,moduleID,ulmID,marksAwarded, >lecturerID) > ModuleContents(moduleID,ulmid) > >These tables would be a bit ugly and meaningless to display, instead I >created a set of views... > > ulmview (ulmID,ulmname,lecturerID,ulmname,marksAvaialble) > mnview (modulenameID, modulename, lecturerID, lecturername) > mcview (modulenameID, modulename, ulmid, ulmname) > smview (studentID, studentname, moduleID, modulename) > spview (studentprogressID,studentID, studentname, moduleID, >modulename, >ulmID, ulmnmae, lecturerID, lecturername, marksAwarded) > >Displaying , adding, updating and deleteing entries in the base tables >work >great. Although I can verify that the actual database has changed, the >display has not reflected this. If I refresh the browser display (F5), ie >reload the url, the data is now displayed. > >AS3 function to add a new record > >public function AddStudentModules_clickHandler(event:MouseEvent):void >{ /* > This function adds a row to the student_modules base table > */ > > // create new student_modules record > var studentModules2:Student_modules = new Student_modules(); > > studentModules2.student_id = parseInt(studentID); > studentModules2.module_id = parseInt(moduleID); > > // add to Table > studentmodulesResult.token = >studentmodulesService.createStudent_modules(studentModules2); > studentmodulesService.commit(); > > // retrieve new list > studentmodulesResult.token = >studentmodulesService.getAllStudent_modules(); > > // redraw datagrid ... retrieve spview table from view > spviewResult.token = spviewService.getAllSpview(); > > > // clear data entry variables > studentID = 0; > moduleID = 0; >} > >mxml part > ><s:AsyncListView list="{spviewResult.lastResult}"/> > >Any pointers would be appreciated. > >Regards >SmileySnr > > > >-- >View this message in context: >http://apache-flex-users.2333346.n4.nabble.com/AS3-Zend-Framework-and-data >grid-updates-after-add-update-or-delete-operations-on-a-Database-table-tp5 >696.html >Sent from the Apache Flex Users mailing list archive at Nabble.com.
