Delete row in list control not working

[tirani]

I have 3 list controls (with detail view) in my mobile app and along with each are associated Save, New, Delete, Sync & Refresh buttons. I have the same issue with all 3 lists - which are otherwise working fine. I'd like to do away with the Sync and Refresh buttons to simplify the process.

Before making the change below, when I selected a row and touch 'Delete' the row is marked for deletion. When I then touch 'Sync' the row is removed from the list and the SQL database table is updated accordingly - all good.

What I want is for the 'Delete' button to do the delete and then sync the list. So, I modified the click event for the delete button to include the standard actions from both the delete and sync buttons as follows:

var lObj = {dialog.object}.getControl('DOWNTIMELIST');
lObj.deleteRow();
{dialog.object}.saveListEdits('DOWNTIMELIST',{rows: 'allRows'});

The last line above is exactly as it is in the Sync click event.

However, this doesn't work. I still have to touch 'Delete' followed by 'Sync' to complete the process. I've tried wrapping saveListEdits in a timeout in case there was some odd timing issue but this made no difference.

This same concept is working fine for the save process.

var lObj = {dialog.object}.getControl('DOWNTIMELIST');
lObj.updateListFromUXControls();
{dialog.object}.saveListEdits('DOWNTIMELIST',{rows: 'allRows'});

Does anyone have any ideas on why this isn't working for the delete?

[kenshap]

Re: Delete row in list control not working

I have 3 list controls (with detail view) in my mobile app and along with each are associated Save, New, Delete, Sync & Refresh buttons. I have the same issue with all 3 lists - which are otherwise working fine. I'd like to do away with the Sync and Refresh buttons to simplify the process.

Before making the change below, when I selected a row and touch 'Delete' the row is marked for deletion. When I then touch 'Sync' the row is removed from the list and the SQL database table is updated accordingly - all good.

What I want is for the 'Delete' button to do the delete and then sync the list. So, I modified the click event for the delete button to include the standard actions from both the delete and sync buttons as follows:

var lObj = {dialog.object}.getControl('DOWNTIMELIST');
lObj.deleteRow();
{dialog.object}.saveListEdits('DOWNTIMELIST',{rows: 'allRows'});

The last line above is exactly as it is in the Sync click event.

However, this doesn't work. I still have to touch 'Delete' followed by 'Sync' to complete the process. I've tried wrapping saveListEdits in a timeout in case there was some odd timing issue but this made no difference.

This same concept is working fine for the save process.

var lObj = {dialog.object}.getControl('DOWNTIMELIST');
lObj.updateListFromUXControls();
{dialog.object}.saveListEdits('DOWNTIMELIST',{rows: 'allRows'});

Does anyone have any ideas on why this isn't working for the delete?

Hi, in the detail view there is a sync policy option that may help you out. Basically it sets the client to server sync automatically when ever there is an Internet connection.

[tirani]

Re: Delete row in list control not working

Thanks Ken

I was aware of that setting but hadn't tried it. I've updated the app to use the client-to-server policy and it does indeed get around the issue.

I'd still like to know why the code used above for the delete does not work though.

[kenshap]

Re: Delete row in list control not working

Thanks Ken

I was aware of that setting but hadn't tried it. I've updated the app to use the client-to-server policy and it does indeed get around the issue.

I'd still like to know why the code used above for the delete does not work though.

Okay, here's my guess as I am swimming in the same waters as you as to how the sync process works under the covers with the myriad of configurable options. There is a help option for disconnected design in software and it's actually very good. Through a lot of trial and error I got my mobile app working but I don't understand all the bits and pieces.

I think your issue has to do with the asynchronous nature of ajax callbacks and I would use the a5.executethisthenthat function to accomplish this as follows:

When the user presses a button, I call the javascript function uploadSuccess.

function a2() {
var o = {dialog.object}.countRecordsToSynch('LIST5');
alert ('Sending: ' + o.count + ' saved information to server, check each record for errors after upload');
{dialog.object}.saveListEdits('LIST2',{rows: 'allRows'});
}

function a3() {
//alert ('The upload is completed');
var lObj = {dialog.object}.getControl('list5');
var err=lObj.getAllErrors() <------------I'm experimenting with this
alert(JSON.stringify(err));
{dialog.object}.runAction('upload_message');
}

function uploadSuccess () {
A5.executeThisThenThat(a2,a3);
}

Alternative you can use action javascript and check the option for synchronous execution.

[tirani]

Re: Delete row in list control not working

OK, that sounds plausible. So, I turned off the sync policy for one of the lists and changed the click event for the delete button to the following.

function d1() {
var lObj = {dialog.object}.getControl('BLOWUPLIST');
lObj.deleteRow();
}

function d2() {
{dialog.object}.saveListEdits('BLOWUPLIST',{rows: 'allRows'});
}

A5.executeThisThenThat(d1,d2);

Unfortunately, this made no difference!

I've also noticed that after deleting one row (which stays in the list flagged for deletion) if I then delete another row, the row flagged for deletion gets deleted and the second row remains flagged for deletion. This behaviour is the same if I use my original code.

It does seem like a timing issue, as you've suggested, and I'm surprised the above changes made no difference.

I see that there are numerous events relating to list operations, do you know if using these (such as afterDeleteRow) would be any better than just using the built in synchronisation policy?

[kenshap]

Re: Delete row in list control not working

OK, that sounds plausible. So, I turned off the sync policy for one of the lists and changed the click event for the delete button to the following.

function d1() {
var lObj = {dialog.object}.getControl('BLOWUPLIST');
lObj.deleteRow();
}

function d2() {
{dialog.object}.saveListEdits('BLOWUPLIST',{rows: 'allRows'});
}

A5.executeThisThenThat(d1,d2);

Unfortunately, this made no difference!

I've also noticed that after deleting one row (which stays in the list flagged for deletion) if I then delete another row, the row flagged for deletion gets deleted and the second row remains flagged for deletion. This behaviour is the same if I use my original code.

It does seem like a timing issue, as you've suggested, and I'm surprised the above changes made no difference.

I see that there are numerous events relating to list operations, do you know if using these (such as afterDeleteRow) would be any better than just using the built in synchronisation policy?

Hi,

You shouldn't have to go down to those client side events and I can't wrap my head around why this isn't working for you. In my application I have a three tier layout utlimately in a phonegap application with changes only allowed at the lowest level. These means I have an add, insert, delete and sync button and the app works without an internet connection until it comes time to sync. While I wonder with you why this isn't working, in order to avoid driving yourself crazy, maybe set the sync policy in the interim. It's late here and I would like to help but time to go sleep; if I think of anything else I will post back. I'd like to know the answer also.

Also tomorrow I'll see if I can put together a test case with some sample UXs that I have.

[tirani]

Re: Delete row in list control not working

I've already put the sync policy back for now - got to get some user testing done. Thanks for your feedback.