How to get record value in form variables

Classic Servoy
1

I am working with foundset which is loaded dynamically and bound column programmatically that is provided data provider to elements in form programmatically. Loaded all the records. Below is snippet

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

2

Hi,

if you have the colname in a variable (ie. vColName)
you can get the value like: var varname = record[vColName];

if you have typed the colname literally, var varname = record.colname should work.

Hope this helps

3

Thanks Marc,

It worked. As per your code I am able to get value in variable. Given typo still giving me warning
“The property colnm1 is undefined for the type JSRecord”