Fatal error executing Ajax callback: Function: 'search_table_function' was not recognized

[polarbearcus]

This error pops up when i hit the button. But my URL for all AjaxCallBack is correct as I am able to submit data to the database if this function is not called.

Here is my code for better understanding.

cordova.plugins.barcodeScanner.scan(
function(result){
	{dialog.object}.setValue('QRCODE',result.text);
	{grid.Object}.ajaxCallback('G','{Grid.RowNumber}:all','search_table_function','','',{onComplete: function() { {dialog.object}.setValue('dateTxtBox',date);
	{dialog.object}.setValue('timeTxtBox',time);
	if({dialog.object}.getValue('statusTxtBox') == "Duplicated")
		{alert("Duplicated");}
	else
		if({dialog.object}.getValue('statusTxtBox') == "Fresh")
		{alert("Fresh");}
	{dialog.object}.submit();},deviceOfflineFunction: function() {   }});
})

[polarbearcus]

Re: Fatal error executing Ajax callback: Function: 'search_table_function' was not recognized

*bump

[Davidk]

Re: Fatal error executing Ajax callback: Function: 'search_table_function' was not recognized

Sorry... have to ask... do you have a valid XBasic function named "search_table_function"?

I would replace the {grid.Object} ajax callback syntax with the {dialog.Object} version. Not that it matters... it just looks odd.

I would also use a more accepted method of formatting javascript code...

if ({dialog.object}.getValue('statusTxtBox') == "Duplicated") {
	alert("Duplicated");
} else {
	if ({dialog.object}.getValue('statusTxtBox') == "Fresh") {
		alert("Fresh");
	}
}

Don't include the braces around lines of code... makes it hard to read.
As well, reformatting the code easily shows an error in the code you have. Missing a brace is far too common a mistake I make... but formatting the code well helps to spot that error.

This is your code, in error, reformatted... there are 2 errors

if ({dialog.object}.getValue('statusTxtBox') == "Duplicated") {
	alert("Duplicated");
} else
	if ({dialog.object}.getValue('statusTxtBox') == "Fresh") {
		alert("Fresh");
	}

Finally... you have an awful lot going on this in code. The ajax callback is going to fire... but the balance of the javascript code is going to finish running long before the callback even gets warm. Not that it's a problem... just something to be aware of.

To find errors in a bunch of code like this it's best to split up the code into logical blocks. First... make sure the callback works. Next... make sure the javascript if...else works. Test them out in pieces... and then put them together. Otherwise you could have a bunch of errors and never know where.

[polarbearcus]

Re: Fatal error executing Ajax callback: Function: 'search_table_function' was not recognized

The JavaScript code was formmated by A5. This is because I converted the JavaScript action to the JavaScript Text mode and i thought it was going to be fine. I have tried the different part of the codes independently and is working. This follow is my search_table_function XBasic Function

function search_table_function (e as p)
dim search as c
	search = e._currentRowDataNew.realQrResultTxtBox
	dim cn as sql::Connection
	dim sqlSelect as c
	dim args as sql::Arguments
	dim result as l = .f.
	result = cn.Open("{A5API='SQLServer',A5DBVersion=2008,Server='xxx.xxx.xxx.xxx\xxx,xxxx',A5ANSINullPadWarn=Default,UserName='xx',Password='xxxxxx',Database='xQR'}")
	if result then
		sqlSelect = "SELECT * FROM QRScans WHERE QRCode = :newCode"
		args.Add("newCode", search)
		result = cn.Execute(sqlSelect,args)
		if result then
			dim rs as sql::ResultSet
			rs = cn.ResultSet
			dim flag as l
			flag = rs.nextRow()
			if flag then
				e.control.statusTxtBox = "Duplicate";
				else
				e.control.statusTxtBox = "Fresh";
			end if
		end if
		cn.close()
	end if
	debug(1)
end function

*Credits to Govindan Gandhi & Rohan Shenoy

Sorry for a misunderstanding. This XBasic function works in "Working Preview" the fatal error only occurs when I install the app on my device.

Will try to fix the problem with your the help you provided. If after experimenting and if it still unable to work i will post on this thread again. Thank you!

[polarbearcus]

Re: Fatal error executing Ajax callback: Function: 'search_table_function' was not recognized

I've tried and tried multiple times. It works in "Working Preview" but I just keep seeing the error when i scan a barcode. it just keep saying "Fatal error executing ajaxcallback"

[polarbearcus]

Re: Fatal error executing Ajax callback: Function: 'search_table_function' was not recognized

*bump

[imjoken]

Re: Fatal error executing Ajax callback: Function: 'search_table_function' was not recognized

Don't know if it's required but you don't have a return type for your function

[polarbearcus]

Re: Fatal error executing Ajax callback: Function: 'search_table_function' was not recognized

I doubt so, I can do this in "Working Preview" HELP PLEASE!