Checkbox select XBASIC code - update multiple rows in a grid with a detail view

[CharlesParker]

Ok, I copied this post made by a member in another thread but that thread was primarily based on an updatable grid and this excerpt is actually closer to my goal. I started to post this in THAT thread but I firmly beleive that there are others who want to do EXACTLY what I am asking and I think this warrants it's own post. I hope it helps me as well as others.

So the scenario is a typical grid with an editable detail view and the checkbox selector option has been chosen in the properties of the grid.
The goal is that for each row selected I want to be able to update a column "is_active" = 'No' using a button that performs an ajax callback and executes some update sql statement.

SO if I were to write semi-suedo code that worked it might look like this

function changeactive as c (e as p)

args.array = the primarykey for each checked row in an array.
args.set("newval",e.dataSubmitted.Is_Active)

sql = "update mydatabase.table SET Is_Active = :newval WHERE pk IN (:argsarray)"

cn.open("::Name::Connection1")
cn.execute(sql,args)

cn.close()

Refresh the grid
end function



I hope that makes sense, so I came across the below code and have tried my best but cannot figure out how to modify it to do what I want.
which is as I said, check a bunch of rows, click a button and set a value of one of the fields - submit it and refresh the grid!

Can anyone give me a hand and post a proper solution/example (using the below code or otherwise...)

args.xml = e.checkboxFilterArgumentXML
count = args.count

for i= 1 to count
vKeys = vKeys + args[i].data + CRLF()
next i

argument_add_array_argument(args,"array_vKeys","c",vKeys)

sql = "Select Cnt = Count(*) from InvoiceDex where InvoiceDex_ID IN (:array_vKeys)"

flag = cn.execute(sql, args)

[lvasic]

Re: Checkbox select XBASIC code - update multiple rows in a grid with a detail view

args.xml = e.checkboxFilterArgumentXML
count = args.count

for i= 1 to count
vKeys = vKeys + args[i].data + CRLF()
next i

argument_add_array_argument(args,"array_vKeys","c",vKeys) ****You must use the argument array*****

--sql = "Select Cnt = Count(*) from InvoiceDex where InvoiceDex_ID IN (:array_vKeys)"
sql = "update mydatabase.table SET Is_Active = :newval where pk in (:array_vKeys)"

flag = cn.execute(sql, args)

[CharlesParker]

Re: Checkbox select XBASIC code - update multiple rows in a grid with a detail view

Here is my current non working code:

args.xml = e.checkboxFilterArgumentXML
count = args.count
args.set("newval",e._currentRowDataNew.Job_IsActive)
for i= 1 to count
vKeys = vKeys + args[i].data + CRLF()
next i

argument_add_array_argument(args,"array_vKeys","c",vKeys)
'****You must use the argument array*****

'sql = "Select Cnt = Count(*) from InvoiceDex where InvoiceDex_ID IN (:array_vKeys)"
sql = "update alphanwcopro.jqcalendar SET Job_IsActive = :newval where Id in (:array_vKeys)"

cn.open("::Name::Connection1")
cn.execute(sql,args)
cn.close()
end function

So the first error returned in the debugger is
Property not found args.count subelement not found, this occurs running to the add_array_arguments line...

Furthermore running the xbasic results in no joy, lol.

Thoughts on what I am doing wrong here?
My args.set for the Job_IsActive pulls the info but admittedly this is NOT an array and I would rather get rid of that and just set the value to "No" anyways so that's actually an irrelevant part of the code anyway.

many thanks, and yes it was your snippet I was obviously referring to!

[lvasic]

Re: Checkbox select XBASIC code - update multiple rows in a grid with a detail view

Check out this video: http://www.screencast.com/t/WSf1fwi1M

[lvasic]

Re: Checkbox select XBASIC code - update multiple rows in a grid with a detail view

Also, try testing your script only using the argument array.