- Code: Select all
var sql="<sql statement>"
var ds=databaseManager.getDataSetByQuery('servername',sql,null,100)
var datsource=ds.createDataSource('data')
var frm = solutionModel.getForm('myForm');
frm.dataSource=datsource
forms['formname'].controller.recreateUI()
var elem = frm.getField(forms.formname.elements.colMN.getName());
elem.dataProviderID = 'COLNM';
var fs=databaseManager.getFoundSet(datsource)
fs.loadAllRecords()
forms.formname.foundset.loadRecords(fs)
var index=forms.formname.foundset.getSelectedIndex()
var record=forms.formname.foundset.getRecord(index)
application.output('RECORD :'+record)
var varname=record.colname //store individual values in variables
Here what I want to do.
1. code: record=forms.formname.foundset.getRecord(index). It returns the selected record/row.
2. I want to get individual values in my variable Can I get individual values like-
var varname=record.colname
How to get individual values in variables for a particular record/row. Any suggestion