Hi, I am trying to create a form form with a dataset as seen below. I keep getting an error saying that the dataset property cant be set, I’m guessing due to memory issues. Any ideas from you guys?
“TypeError: Cannot set property “dataSource” of to “mem:my_id” (C:\Users\westley\servoy_workspace\customergrid\forms\ledger.js#19)
TypeError: Cannot set property “dataSource” of to “mem:my_id” (C:\Users\westley\servoy_workspace\customergrid\forms\ledger.js#19)
at C:\Users\westley\servoy_workspace\customergrid\forms\ledger.js:19 (onLoadTest)
at C:\Users\westley\servoy_workspace\customergrid\forms\cust.js:56 (btn_details)”
function onLoadTest(event) {
var dataSource = controller.getDataSource()
var v_sql = "SELECT phone FROM ledger"
var v_ds = databaseManager.getDataSetByQuery("visiondata",v_sql,null,-1);
globals.lDatasource = v_ds.createDataSource('my_id',[JSColumn.TEXT,JSColumn.TEXT,JSColumn.TEXT,JSColumn.TEXT,JSColumn.TEXT,JSColumn.TEXT]);
globals.lDatasource = v_ds.createDataSource('field_name_source', [JSColumn.TEXT, JSColumn.TEXT, JSColumn.TEXT]);
var v_form = solutionModel.getForm('student_i_diagnostics');
v_form.dataSource = globals.lDatasource;
var fs = databaseManager.getFoundSet(globals.lDatasource);
var v_field_1 = v_form.getField('field1');
v_field_1.dataProviderID = "vDesc";
controller.recreateUI();
application.updateUI();
}