Saving list detail records

[lgrupido]

Can someone give me a sure fire way to save and synchronize a list detail record all at the same time? The save and synchronize functions are two distinct things, but most of the time I want the save and sync to happen at the same time. There is no reason most of the time for the processes to be different.

But when I try to combine the scripts into a single function, I often run into what looks like timing errors. Sometimes the sync happens too quickly (or the save happens too slowly) and it doesn't actually happen. You go back to the list, and despite the fact that you have run the sync code, you still have a little mark in the corner of the record. Doing a manual sync then fixes the issue.

But I want to eliminate any need for a manual sync.

Has anyone else run into an issue like this?

[Davidk]

Re: Saving list detail records

I can't remember running into an issue like this. The save edits is all client-side and happens fast. Could be you're doing something to hold things up.

However, use A5.runChain to ensure the sync happens only after the save.

function saveEdits(obj) {
	var lObj = {dialog.object}.getControl('LISTCUST');
	lObj.updateListFromUXControls();
	obj.next();
}

function syncList(obj) {
	{dialog.object}.saveListEdits('LISTCUST',{rows: 'allRows'});
	obj.next();
}

//create an array with the functions to executed
var actions = [saveEdits,syncList];

//run the actions synchronously
A5.runChain(actions,
    function() { alert('alldone'); },
    function(err) { alert('error: ' + err); }
);

https://www.alphasoftware.com/docume...n%20Method.xml

[dbinns]

Re: Saving list detail records

you can set the list to sync policy in the list to do a client to server sync everytime you save an edit (you only need to save).

Due to my apps being offline at times I do have a sync button that is hidden unless there are unsync'd records so someone offline can go back and force a sync without creating a record to do so.

[RichCPT]

Re: Saving list detail records

David,
I think the saveListEdits is going to return control to javascript immediately after submitting the request to the server, unless there is some way you can tell that function (with its AJAX call) to sit and wait for the server's response.

ALL,
If the user sync's edits from the LIST to the server immediately after each row and if the syncs are run asynchronously through AJAX will it be safe or okay to possibly have the server trying to process these requests concurrently?

Maybe I am making this too complicated, but in my updateable LIST I put up "Please wait..." message that locks the screen when the LIST is being sync'd to the server. On the server-side 'afterAjaxCallback' event I have code that checks for the Persist Data event and inserts JavaScript into the response to clear the "Please wait..." message. The "Please wait..." message also has a timeout of 30 seconds, to hide itself and display an error message if a response is not received from server in that amount of time. For the record here is what that code looks like:

function afterAjaxCallback as v (e as p)[INDENT]'Fires after the Ajax callback has completed. You code can modify the response sent to the client.
'Variables in the 'e' object include:
'e.tmpl - definition of the UX component	
'e.ajaxResponse - the response that will be sent to the client.

'e.action = Ajax callback action type
'e.callbackFunctionName = Ajax callback specific action

if e.action = "GenericAjaxCallback" .AND. e.callbackFunctionName = "system:persistListData"
	'-- Clear the please wait message after saving list data
	e.ajaxResponse = "CP_HidePleaseWait();" + crlf() + e.ajaxResponse
end if[/INDENT]

end function

[lgrupido]

Re: Saving list detail records

I have checked that box before. I'm not sure it does what it says it does reliably.

[Davidk]

Re: Saving list detail records

Rich... maybe I've misread Larry's post but I didn't think waiting for the server return was his issue... he can clarify. He didn't mention where the "corner indicator" was or what colour it was, but he mentioned possible timing issues between save and sync. We also don't know what's going on during a save... what else he's got firing.

[lgrupido]

Re: Saving list detail records

For me, the problem primarily happens when you use the list delete function to delete a record from the list. Just a general save works but deleting a record seems to require a separate sync, no matter what the settings are.

[dbinns]

Re: Saving list detail records

Larry in my limited experience it works well. I am new to this but I've had an 4 instances of an application running using this method for 90 days 24/7 and I've seen no issues.

I am not deleting records however. You may need to add a sync event to the delete record button?

[Davidk]

Re: Saving list detail records

So it's not an edit, save, sync... but rather a delete, save, sync that is causing the issue? That's very specific info.

[lgrupido]

Re: Saving list detail records

I can't seem to duplicate a save, sync issue, but I definitely have a delete, sync issue.

I am trying to come up with a sample I can post for you to test.

I am having trouble wrapping the predefined functions that save and sync lists into either the runchain or the executethisthenthat javascript functions to see if I can get it to work that way.

I keep getting javascript errors.

[lgrupido]

Re: Saving list detail records

I think I "solved" the issue.

When you delete records in a list, you still have to save the records before the delete will actually take place. (similar to how a grid works.)

I wasn't doing the save step, just the delete step.

If you delete, then save, it works fine so far as I can tell.