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-datagrid-updates-after-add-update-or-delete-operations-on-a-Database-table-tp5696.html
Sent from the Apache Flex Users mailing list archive at Nabble.com.
