afterDialogValidate Server-Side Event Question

[mikeallenbrown]

Within the afterDialogValidate event is there a method I could use to detect if a new record was just saved?

What I need to do is perform a separate SQL insert but only after a new record has been saved. That insert also needs the primary key of that new record to use in an argument.

I came up with this for my save button but quickly realized how poor a method it is ...

var _id = {dialog.object}.getValue('ID');

if (_id.length > 1){
	//Exisiting Record
	{dialog.object}.submit();
} else {
	//New record
	{dialog.object}.submit();
	
	//Timeout for save to finish
        setTimeout(function(){
		{dialog.object}.ajaxCallback('','','Save_New_Record','','');
	}, 3500);
}

I know I could do this in a SQL trigger but I'm trying to avoid that.

[GGandhi]

Re: afterDialogValidate Server-Side Event Question

Within the afterDialogValidate event is there a method I could use to detect if a new record was just saved?

[click on the actionJavascript to show the variables exposed it will show the flag and the primary key]
yes, after the action javascript you can enter this comman
if rtc_flag_record_was_saved then ' the record was saved

do what you needs to do

end if

What I need to do is perform a separate SQL insert but only after a new record has been saved. That insert also needs the primary key of that new record to use in an argument.

the primary key will be there
the exact code is in the example if you do click to see the variables, that you can use it.

[GGandhi]

Re: afterDialogValidate Server-Side Event Question

sorry, it should be click on the actionjavascript then click on the action javascript menu above.

[Ronald Anusiewicz]

Re: afterDialogValidate Server-Side Event Question

Mike, I have very little experience with SQL. The one app where I do use SQL, I have this code in the afterDialogValidate event. Debug(1) will show what is returned. You can edit the last line which is action javascript and there is a built in feature to do what you want.

function afterDialogValidate as v (e as p)
	debug(1)
	e.datasubmitted.site = upper(e.datasubmitted.site)
	e.datasubmitted.tail = upper(e.datasubmitted.tail)
	e.datasubmitted.descript = w_upper(e.datasubmitted.descript)
	e.datasubmitted.notes = w_upper(e.datasubmitted.notes)
	e.datasubmitted.intials = upper(e.datasubmitted.intials)
	e.datasubmitted.TimeStamp = TIME("MM-dd-yy, h:0m", NOW() )
	
	dim cn as sql::Connection
	dim flag as l
	cnString = "::Name::AF_WOLog"
	table = "wo_log"
	
	flag =cn.Open(cnString)
	if flag = .f. then
		e.javascript = "alert('Sorry, Unable to Open Table');"
		end
	end if
	
	cn.PortableSQLEnabled=.t.
	dim args as sql::Arguments
	args.Set("ThisSite",e.datasubmitted.site)
	
	dim sqlstatement as c
	sqlstatement=<<%sql%
SELECT MAX(wo) 
FROM wo_log 
WHERE site=:ThisSite
%sql%
	flag=cn.Execute(sqlstatement,args)
	if flag = .f. then
		e.javascript = "alert('Sorry, Unable to Execute Process');"
		cn.Close()
		end
	end if
	
	dim rs as sql::ResultSet
	rs=cn.ResultSet
	nr=rs.nextrow()
	if nr = .f. then
		xd="0"
	else
		xd=rs.data(1)
	end if
	e.datasubmitted.wo = alltrim(str(val(xd)+1))
	cn.close()
	
	'e.javascript = "alert(" + e.datasubmitted.wo + ");"
	
	'To edit this action, place insertion point anywhere in the command, then click the 'Action Scripting' button'.
	ExecuteServerSideAction("Save Data::Save_Submitted_Data_to_WO_LOG_Table")
	
end function

ADVEvent.JPG

[mikeallenbrown]

Re: afterDialogValidate Server-Side Event Question

Thanks guys. I found the e object I need: e.rtc.primaryTablePrimaryKey

I debugged the ExecuteServerSideAction("Save Data::Save_Submitted_Data_to_Table_s_") specifically looking for such a thing but apparently didn't notice it until Gandhi replied.

[GGandhi]

Re: afterDialogValidate Server-Side Event Question

https://www.screencast.com/t/g73PXW0B8

this is the variable and the primary key
these are exposed via
this step
https://www.screencast.com/t/PftTCIjMYKQ

the disadavantage of using Max(id) is that if someone else saves a record you will get wrong data, in this step you do not. all connection strings will get their primary key as receipt regardles of how many connections to the backend.

[Ronald Anusiewicz]

Re: afterDialogValidate Server-Side Event Question

What my script is doing, it's creating a new Work Order number after a submit. The table contains work order numbers for multiple locations. The work order number is sequential for each location. After the submit, the next work order number is determined by finding the highest number filtered by that location and then incremented by 1. It is possible that all locations have the exact same work order number. The work order number also has an alphabet code attached to define the location. So I can have BAF-10123 and ORH-10123.

I'm not sure what the key value would do for me.

Thank you for your concern.

[GGandhi]

Re: afterDialogValidate Server-Side Event Question

okay now it is clear that you create an unique id, the key value will not offer any improvement since it only returns autoincrement id and an integer value.