Rank: Advanced Member
Groups: Registered
Joined: 7/31/2014(UTC) Posts: 40 Location: sterling, VA
|
tried again with edit fuction. this time system crashed. but the changed result did saved in backend table. see attached with dmp file. after update node, there is SAVE node command.
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Joined: 7/21/2014(UTC) Posts: 498
Was thanked: 88 time(s) in 88 post(s)
|
Thanks for new dump files. Both crashes had the same reason - you are reloading $DB2 within Even Entry, which is not necessary - when subpage is closed, MobileTogether will automatically update $DB2 with the data from the mapped tree. So, just remove the "Reload $DB2" command from ADD and EDIT button scripts - this will work quicker and will avoid crash, and we will make sure in the next release to not crash in such cases. Here is the screenshot of the EDIT button actions: bbv attached the following image(s):
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Joined: 7/21/2014(UTC) Posts: 498
Was thanked: 88 time(s) in 88 post(s)
|
Note: now as you are using a SELECT statement for $DB3, it will return only Row with correct Primary Key combination - not all rows like in the past. This means, that there is no need anymore to search for a correct Row when updating nodes in $DB3 with EDIT button. So we can simplify it like this: bbv attached the following image(s):
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Joined: 7/21/2014(UTC) Posts: 498
Was thanked: 88 time(s) in 88 post(s)
|
In order to make the ADD button work you need to append a new Row to the $DB3 RowSet and then Save $DB3. It is correct, that $DB3 is blank for new entries - when you add a new Row and Save, MobileTogether will see there is a new Row and will generate an INSERT statement. bbv attached the following image(s):
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 7/31/2014(UTC) Posts: 40 Location: sterling, VA
|
Followed your instruction, for ADD button, using APPEND node (append a new Row to the $DB3 RowSet) and SAVE node $DB3 (not use Insert Node). Also took out Reload $DB2, HOWEVER, the new record did saved into database, but the application still crashed. please see attached DMP file.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 7/31/2014(UTC) Posts: 40 Location: sterling, VA
|
attached MID file for you review.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 7/31/2014(UTC) Posts: 40 Location: sterling, VA
|
when edit again, application crashed. see attached dmp file.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 7/31/2014(UTC) Posts: 40 Location: sterling, VA
|
Thanks for your kind helps, Final I got this application works as we expected. We can edit or add new record. we also combined ADD and EDIT into one button SAVE. So we do not push resposibility to user side. System can handle such logic based on condition. There is no crash happen again. attached is latest MID file for you review.
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Joined: 7/21/2014(UTC) Posts: 498
Was thanked: 88 time(s) in 88 post(s)
|
I'm happy about your success, though you still have one Goto Subpage call too much, which currently causes all the crashes reported by you (this will be fixed), but also does not make sense. In your QUIT button action, you call Go to Subpage "event" in order to return to your parent sub page, though all you need is the Close Subpage call which you have anyway. Just remove Go to Subpage here and everything should be fine. bbv attached the following image(s):
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.