How to get dirtyRowsInSection row count?

[askoog66]

I think I need to know how many rows are in the e.repeatingSectionInfo[].dirtyRowsInSection object.

The only row count objects in repeating section are totalRowCount and rowCount of which neither will give me the above info.

I am trying to set two columns in my SQL database backend that track who and what time a user changed/added a row in a repeating section.

I realize I could setup a trigger in the backend, for the date/time, but cannot get the user id and would prefer to keep all of my programming code in Alpha 5. I am trying to keep my Postgres backend just as a big bucket with nothing fancy going on in it.

Once I get the row count, I can dimension a variable array to get the dirty rows #'s and then add my two columns to the dirtyFieldsInSection object.

Thanks for the help.

[TheSmitchell]

Re: How to get dirtyRowsInSection row count?

I think I need to know how many rows are in the e.repeatingSectionInfo[].dirtyRowsInSection object.

The only row count objects in repeating section are totalRowCount and rowCount of which neither will give me the above info.

I am trying to set two columns in my SQL database backend that track who and what time a user changed/added a row in a repeating section.

I realize I could setup a trigger in the backend, for the date/time, but cannot get the user id and would prefer to keep all of my programming code in Alpha 5. I am trying to keep my Postgres backend just as a big bucket with nothing fancy going on in it.

Once I get the row count, I can dimension a variable array to get the dirty rows #'s and then add my two columns to the dirtyFieldsInSection object.

Thanks for the help.

So, you could count them manually either client-side

//javascript
var repSec = {dialog.Object}.repeatingSections['REPSECID'];
var dirty = 0;
for (var i = 1; i <= repSec.rows; i++) {
    if ( repSec._r[0].i[i-1].dirty ) {
        dirty++;
    }
}

Or server-side

//in afterDialogValidate server-side event (xbasic)
dim dirtyNonDeletedRowsInSection as n = line_count(e.repeatingSectionInfo[].dirtyNonDeletedRowsInSection)
dim dirtyRowsInSection as n = line_count(e.repeatingSectionInfo[].dirtyRowsInSection)

The dirtyNonDeletedRowsInSection appears undocumented.
---
Sarah

[askoog66]

Re: How to get dirtyRowsInSection row count?

This is what I came up with after working on all day. It doesn't work

dim dirtyrowcount as n
dim rownum as n
dirtyrowcount = line_count(e.repeatingSectionInfo[1].dirtyRowsInSection)
FOR counter = 1 to dirtyrowcount
	rownum = e.repeatingSectionInfo[1].dirtyRowsInSection[counter]
	e.datasubmitted.mastermoddatetime[rownum] = now()
	e.datasubmitted.mastermodempid[rownum] = session.userid
	e.dirtyColumns = e.dirtyColumns + crlf() + \
		"mastermoddatetime[" + rownum + "]" + crlf() +  \
		"mastermodempid[" + rownum + "]"
NEXT

If I substitute a number for variable rownum like this...it works

dim dirtyrowcount as n
dim rownum as n
dirtyrowcount = line_count(e.repeatingSectionInfo[1].dirtyRowsInSection)
FOR counter = 1 to dirtyrowcount
'	rownum = e.repeatingSectionInfo[1].dirtyRowsInSection[counter]
rownum = 3
	e.datasubmitted.mastermoddatetime[rownum] = now()
	e.datasubmitted.mastermodempid[rownum] = session.userid
	e.dirtyColumns = e.dirtyColumns + crlf() + \
		"mastermoddatetime[" + rownum + "]" + crlf() +  \
		"mastermodempid[" + rownum + "]"
NEXT

Testing is being done on a repeating section with two existing rows and having a third added to it. I realize this is the most basic of testing and I will want to make sure that if rows 1,3,4 are modified, only they are so modified in the mastermoddatetime and mastermodempid columns of the repeating section.

Thanks for looking

[TheSmitchell]

Re: How to get dirtyRowsInSection row count?

This is what I came up with after working on all day. It doesn't work

dim dirtyrowcount as n
dim rownum as n
dirtyrowcount = line_count(e.repeatingSectionInfo[1].dirtyRowsInSection)
FOR counter = 1 to dirtyrowcount
	rownum = e.repeatingSectionInfo[1].dirtyRowsInSection[counter]
	e.datasubmitted.mastermoddatetime[rownum] = now()
	e.datasubmitted.mastermodempid[rownum] = session.userid
	e.dirtyColumns = e.dirtyColumns + crlf() + \
		"mastermoddatetime[" + rownum + "]" + crlf() +  \
		"mastermodempid[" + rownum + "]"
NEXT

If I substitute a number for variable rownum like this...it works

dim dirtyrowcount as n
dim rownum as n
dirtyrowcount = line_count(e.repeatingSectionInfo[1].dirtyRowsInSection)
FOR counter = 1 to dirtyrowcount
'	rownum = e.repeatingSectionInfo[1].dirtyRowsInSection[counter]
rownum = 3
	e.datasubmitted.mastermoddatetime[rownum] = now()
	e.datasubmitted.mastermodempid[rownum] = session.userid
	e.dirtyColumns = e.dirtyColumns + crlf() + \
		"mastermoddatetime[" + rownum + "]" + crlf() +  \
		"mastermodempid[" + rownum + "]"
NEXT

Testing is being done on a repeating section with two existing rows and having a third added to it. I realize this is the most basic of testing and I will want to make sure that if rows 1,3,4 are modified, only they are so modified in the mastermoddatetime and mastermodempid columns of the repeating section.

Thanks for looking

e.repeatingSectionInfo[1].dirtyRowsInSection is a CRLF delimited character list. It doesn't support []. And, secondly, if it did, I believe you would get a character type back and not a number, so you'll also want to use convert_type(). Try this instead:

dim rownum as n
FOR EACH row IN e.repeatingSectionInfo[1].dirtyRowsInSection
	rownum = convert_type(row, "N")
	e.datasubmitted.mastermoddatetime[rownum] = now()
	e.datasubmitted.mastermodempid[rownum] = session.userid
	e.dirtyColumns = e.dirtyColumns + crlf() + \
		"mastermoddatetime[" + rownum + "]" + crlf() +  \
		"mastermodempid[" + rownum + "]"
NEXT

You can read more about iterating through lists, as well as arrays and collections, here: http://wiki.alphasoftware.com/~alpha...ons,+and+Lists

I find the lack of [] support for lists (and character types) to be aggravating. I always try to use operator[] only to find myself back on the wiki trying to remember how to use the FOR EACH looping mechanism.
---
Sarah

[askoog66]

Re: How to get dirtyRowsInSection row count?

Thanks Sara,

I understand what you did which I think does the same thing I was doing, only more elegantly.

I still cannot get it to work. There is a definite problem with the FOR EACH NEXT loop. If I comment out the FOR EACH and NEXT and substitute in:

row=e.repeatingSectionInfo[1].dirtyRowsInSection

everything works fine as long as I enter/change one item at a time which is to be expected because I am only setting the first line of the array. Fore some reason, your code is not going through the array. I have captured the array in another variable when I change multiple lines and the array has the multiple lines. Therefore, something with the FOR EACH NEXT loop is not working. Don't understand why, seems like pretty simple code set.

I appreciate your continued help.

[TheSmitchell]

Re: How to get dirtyRowsInSection row count?

Thanks Sara,

I understand what you did which I think does the same thing I was doing, only more elegantly.

I still cannot get it to work. There is a definite problem with the FOR EACH NEXT loop. If I comment out the FOR EACH and NEXT and substitute in:

row=e.repeatingSectionInfo[1].dirtyRowsInSection

everything works fine as long as I enter/change one item at a time which is to be expected because I am only setting the first line of the array. Fore some reason, your code is not going through the array. I have captured the array in another variable when I change multiple lines and the array has the multiple lines. Therefore, something with the FOR EACH NEXT loop is not working. Don't understand why, seems like pretty simple code set.

I appreciate your continued help.

It's entirely probably likely that my code is wrong. I'll see if I can work it out and post a real, actually tested example of looping through dirtyRowsInSection

---
Sarah

[TheSmitchell]

Re: How to get dirtyRowsInSection row count?

Thanks Sara,

I understand what you did which I think does the same thing I was doing, only more elegantly.

I still cannot get it to work. There is a definite problem with the FOR EACH NEXT loop. If I comment out the FOR EACH and NEXT and substitute in:

row=e.repeatingSectionInfo[1].dirtyRowsInSection

everything works fine as long as I enter/change one item at a time which is to be expected because I am only setting the first line of the array. Fore some reason, your code is not going through the array. I have captured the array in another variable when I change multiple lines and the array has the multiple lines. Therefore, something with the FOR EACH NEXT loop is not working. Don't understand why, seems like pretty simple code set.

I appreciate your continued help.

Ha ha ha. I forgot that to access the data in x in your FOR EACH x IN y you have to use .value:

dim rownum as n
FOR EACH row IN e.repeatingSectionInfo[1].dirtyRowsInSection
	rownum = convert_type([COLOR="#FF0000"][B]row.value[/B][/COLOR], "N")
	e.datasubmitted.mastermoddatetime[rownum] = now()
	e.datasubmitted.mastermodempid[rownum] = session.userid
	e.dirtyColumns = e.dirtyColumns + crlf() + \
		"mastermoddatetime[" + rownum + "]" + crlf() +  \
		"mastermodempid[" + rownum + "]"
NEXT

This is the demo I wrote to debug:

function afterDialogValidate as v (e as p)

	'demo loop
	debug(1)
	dim js as c = ""
	dim msg as c = ""
	for each row in e.repeatingSectionInfo[1].dirtyRowsInSection
		dim rowNum as n = convert_type(row.value,"N")
		msg = msg + rowNum + ","	
	next
	
	js = "alert('" + js_escape(msg) + "');"
	e.javascript = js

end function

[askoog66]

Re: How to get dirtyRowsInSection row count?

Thank you Sara.....sorry for the delay between snowplowing and my mis-typed variable causing headaches.

This is what I ended up with

dim rownum as n
FOR EACH row in e.repeatingSectionInfo[1].dirtyRowsInSection
	rownum = convert_type(row.value, "N")
	e.datasubmitted.addrmoddatetime[rownum] = now()
	e.datasubmitted.addrmodempid[rownum] = session.userid
	e.dirtyColumns=e.dirtyColumns + crlf() + \
		"addrmoddatetime[" + rownum + "]" + crlf() +\
		"addrmodempid[" + rownum + "]"

Just as an aside for someone who may find this discussion....the above code will have to be duplicated for each repeating section. Also, you have to make sure you change the appropriate variables for each control in the repeating section. Also make sure you change the number in the e.RepeatingSectionInfo[] object.

[TheSmitchell]

Re: How to get dirtyRowsInSection row count?

Thank you Sara.....sorry for the delay between snowplowing and my mis-typed variable causing headaches.

This is what I ended up with

dim rownum as n
FOR EACH row in e.repeatingSectionInfo[1].dirtyRowsInSection
	rownum = convert_type(row.value, "N")
	e.datasubmitted.addrmoddatetime[rownum] = now()
	e.datasubmitted.addrmodempid[rownum] = session.userid
	e.dirtyColumns=e.dirtyColumns + crlf() + \
		"addrmoddatetime[" + rownum + "]" + crlf() +\
		"addrmodempid[" + rownum + "]"

Just as an aside for someone who may find this discussion....the above code will have to be duplicated for each repeating section. Also, you have to make sure you change the appropriate variables for each control in the repeating section. Also make sure you change the number in the e.RepeatingSectionInfo[] object.

Congrats on getting some working code! :D

Sorry you got more snow. We have snow, but the kind that fell a month ago and is just now seeing the light of day. 50s this weekend... DIE, SNOW! DIE!