I am trying to make an AJAX call from a PhoneGAP hosted UX using the built-in functions calling to the SQLite functions on the development server to create a database and copy it to the mobile device, and another call to the plugins on the mobile device to open the DB and populate a list control. The project builds with no errors, but when I run it, the callback to the function to create the DB fails, showing the following in the server logs:
Server Error Log:
Xbasic Error Log:
I have two drop-down controls, two list controls, and two buttons running on this UX component.
The first drop-down is populated at run-time, and when I change an item in the list, it populates the second drop-down with selected records using an AJAX callback. When an item is chosen from the second drop-down, the first list control is populated with selected records which are also returned from the server using an AJAX callback; these callbacks work well, every time.
The second list control is meant to be populated from a local SQLite database which is created on the server, and then downloaded to the mobile device, automatically, via the actionScript items presented by the Alpha development environment, as in the examples and tutorials. This second list control has the two buttons beneath it, the first one creates the database on the server and waits for the download to complete, and the second button is supposed to open the local copy of the database on the mobile device, and then populate the second list box, but the function fails.
Should I not be attempting to use two different AJAX callbacks to manipulate two different databases?
Server Error Log:
Code:
[Mon Mar 14 17:55:37 2016] [error] (Internal Server Error: C:\A5Webroot\__a5RunDialog.a5w) Script Error: Error:Script:a5dialoghelper_ajaxcallback_createSQLiteDb() line:21 - Not found
Code:
Mon Mar 14 17:55:37 2016 Not found Execution Stack: 0#1 evaluate_shared_private( 0#37 OOhttpdServerClientMIME(ptemp,"AppServerMain") 0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.ScriptName),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path) 0#169 x_out = a5_ajax_dialog2(tmpl) ========================================================== Mon Mar 14 17:55:37 2016 Script:a5dialoghelper_ajaxcallback_createSQLiteDb() line:21 Not found Execution Stack: 0#1 evaluate_shared_private( 0#37 OOhttpdServerClientMIME(ptemp,"AppServerMain") 0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.ScriptName),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path) 0#169 x_out = a5_ajax_dialog2(tmpl) ========================================================== Mon Mar 14 17:55:37 2016 Thread: AppServerWorker6 Request URI: /__a5RunDialog.a5w?__dialogFilename=BLOCK_INSTRUCTION_MANAGER&__alias=DLG1&__unsaved=no Script: " /__a5RunDialog.a5w" Line: 169 x_out = a5_ajax_dialog2(tmpl) Script:a5dialoghelper_ajaxcallback_createSQLiteDb() line:21 Not found Execution Stack: 0#1 evaluate_shared_private( 0#37 OOhttpdServerClientMIME(ptemp,"AppServerMain") 0#2 A5WCallResult = evaluate_a5w_to_response(page_contents,Response,quote(" " + eval_settings.global.Request.ScriptName),eval_settings,EVALUATE_A5W_TIMEOUT,RequestBundle.RequestInfo.Filename.Path) 0#169 x_out = a5_ajax_dialog2(tmpl)
The first drop-down is populated at run-time, and when I change an item in the list, it populates the second drop-down with selected records using an AJAX callback. When an item is chosen from the second drop-down, the first list control is populated with selected records which are also returned from the server using an AJAX callback; these callbacks work well, every time.
The second list control is meant to be populated from a local SQLite database which is created on the server, and then downloaded to the mobile device, automatically, via the actionScript items presented by the Alpha development environment, as in the examples and tutorials. This second list control has the two buttons beneath it, the first one creates the database on the server and waits for the download to complete, and the second button is supposed to open the local copy of the database on the mobile device, and then populate the second list box, but the function fails.
Should I not be attempting to use two different AJAX callbacks to manipulate two different databases?