Strange List update behaviour

[[email protected]]

I have a strange problem with one of my lists. I'll try to explain it clearly but its a little complicated:

1. I have a list called "PHOTO_LIST" which has 4 fields: Id, name, overview and image.
2. It is a child of another list called "ASSET_LIST".
3. PHOTO_LIST has a detail view which consists of 3 UX controls: photo_name (textarea), photo_overview (checkbox) and photo_image (image)
3. In the db, photo_name is a char field, photo_overview is a tinyint and photo_image is a medium blob.

This is the problem:
- everything works fine when I'm online (that is, there is a connection to the server). I can add a new image with a name and tick or not tick the overview. (the values for overview are either true or false, displayed as 'T' or 'F'. So when I add the first image, the overview box is ticked by default. I can add a second image, and if I tick the 'overview' checkbox, when I hit the save button there is some code that runs that will check all the rows in the PHOTO_LIST, and if it is set to 'T', it will change it to 'F' by using the method "updateTableRow". So only one row can have the overview set to 'T' at any time - all the rest should be set to 'F'.

- however, when I stop the server, that is, simulate a disconnect, I get this strange problem happening. If I add more than one image: say I add the first image which by default has the overview field ticked, and then add a second image and manually tick the overview field, then when I come back online and sync up the list with the server, I get an erroneous row inserted in the list between the first and second rows. It seems to be related to the code that sets the overview field because when I comment it out, the problem doesn't happen (of course the check to ensure only one overview is checked doesn't happen, so this is not ideal).

Here is that piece of code:

var oview = {dialog.Object}.getValue('photo_overview');
if (oview == true) {
	for (var i=0;i < lObj._rData.length; i++) {
		if ({dialog.object}.getValue('list::PHOTO_LIST::overview', i)== 'T' || {dialog.object}.getValue('list::PHOTO_LIST::overview', i)== true) {
			lObj.updateTableRow(i,{overview: false});
		}
	}
	lObj.refresh();
}
lObj.updateListFromUXControls();

if (window.online == true) {
	{dialog.object}.saveListEdits('PHOTO_LIST',{rows: 'allRows'});
}

So if I'm online, I will do a .saveListsEdits straight away. If I'm offline, I have a "Sync" button which basically does a .saveListEdits (when back online).

I've included an image of what the list looks like when I have this problem:
photo list problem.PNG

[Davidk]

Re: Strange List update behaviour

List controls within Alpha have a different strange behaviour per release. You must include the version/build you're using. The release either side of your release may not exhibit the same behaviour.

There are so many combinations of settings for a List Control with a Detail View and Images that it would be impossible to try and duplicate what you're seeing. The best scenario would be for you to post your UX and a SQL Dump of your table. I'm assuming SQL of some type, although you've not mentioned that.

[[email protected]]

Re: Strange List update behaviour

Version 12.4.5.4.6 build 5445 which I believe is the latest release. I'm using mySQL for the db.

I'll need to do some work to cut down my UX before I post it (it has a login framework build in, etc, which I will need to strip out).

[kiwibruce]

Re: Strange List update behaviour

Hi Greg,

Did you ever find a solution to this? as I am having a very similar issue with a child list in a disconnected Web App.

[CharlesParker]

Re: Strange List update behaviour

I think the refresh in the middle of the code might have something to do with it, do you need to refresh the list control object at that point? Is the refresh attempting to happen before the online check? It just seems like you shouldn't attempt a refresh of the list control object when offline, unless I am reading that wrong...