Grid Checkbox Column and Row Data

[mvaughn]

After multiple rows are checked in a grid checkbox column, I want to copy those rows to another table using an ajax callback.
What is the best way to go about this?
How do I access each row's data for the copy?

[GGandhi]

Re: Grid Checkbox Column and Row Data

take a look at version 10 videos #87, that probably will help

[mvaughn]

Re: Grid Checkbox Column and Row Data

Thanks, the video helped. #88 was also helpful.
I have another issue though that involves a textbox... Untitled-1.gif
I'm making an ajax callback to process the row, but the textbox never gets picked up by (e)... callback.gif

function ProcessSelected as C (e as P)

	dim js as C
	dim i as N
	dim selectedCount as N
	dim rowNum as N
	
	dim skillsid as C
	dim categoryid as C
	dim fieldData as N

	'Get number of selected records
	selectedCount = e.checkboxRows.countChecked
	
	'Process key field values of selected rows
	for i=1 to selectedCount
		categoryid = eval("e.checkedRows.key" + i + "[1]")
		skillsid = eval("e.checkedRows.key" + i + "[2]")
		
		rowNum = e.checkboxRows.rows[i] '*** I can get the row number
		fieldData = e._currentRowDataNew.yearsexp '*** how do I get this value?
		
	next

	js="alert('Selected Records Processed');"
	
	' Return javascript code to be executed after callback (optional)
	ProcessSelected  = js

end function

[GGandhi]

Re: Grid Checkbox Column and Row Data

I am not sure..
is this some kind of an applicant filling it in
they will check the box and fill in the years as an applicant will do
normally the way I see all the grid data will be available and you check to select certain rows only.
this looks different!

[mvaughn]

Re: Grid Checkbox Column and Row Data

Yes, the applicant fills in the years after (hopefully) checking the box.
Afterward I want to send that row(s) to another table.

Maybe I'm going about it all wrong. I don't really see the need for checkboxes if YEARS is dirty, but getting the field dirty isn't an exact science from my viewpoint.

[CharlesParker]

Re: Grid Checkbox Column and Row Data

Does e.dirtycolumns help?
http://msgboard.alphasoftware.com/al...e.dirtycolumns

[GGandhi]

Re: Grid Checkbox Column and Row Data

why don't you use a dialog to gather information and submit the information?

[mvaughn]

Re: Grid Checkbox Column and Row Data

I tried a dialog but could not get the repeating section to populate based upon a filtered column that is not the primary key.
I finally settled upon this which works nicely but I want to remove the dead space above the embedded grid: space.gif

To help others, here is the xbasic code:

function ProcessSelected as C (e as P)

debug(1)
	dim skillname as c = e._currentRowDataNew.skillname
	dim skillsid as n = convert_type(e._currentRowDataNew.skillsid,"n") 
	dim years as n = convert_type(e._currentRowDataNew.yearsexp,"n")
	dim reg_number as n = 999
	
	dim cn as SQL::Connection
	dim rs as SQL::ResultSet
	dim args as SQL::Arguments
	dim sqlStatement as c
	cn.open("::name::adam")
	
	sqlStatement = "INSERT INTO jobskills (SKILLSID, SKILLNAME, YEARSEXP, REG_NUMBER) VALUES ({skillsid}, '{skillname}', {years}, {reg_number})"
	sqlStatement = evaluate_string(sqlStatement)
	if cn.execute(sqlStatement)=.f.
		save_to_file(sqlStatement + "|" + cn.callresult.text,"c:\a5\logs\grd_Skill_Survey.txt")	
	end if	
	

end function