Creating form from a Dataset

Classic Servoy
1

Hi all… i was trying to create a form from a dataset created by an array. My method code is

                history.removeForm('p')
	solutionModel.removeForm('p')
	
	var a = new Array()
	a = databaseManager.getTableNames(forms.clientes.controller.getServerName())
	var ds = databaseManager.convertToDataSet(a)
	var uri = ds.createDataSource('test', [DM_COLUMNTYPE.TEXT])
	
	var jsform = solutionModel.newForm('p', uri, null, true, 300, 300);
	var f = jsform.newField('ds',SM_DISPLAYTYPE.TEXT_FIELD,100,100,100,20)
	var datapr = f.dataProviderID
	application.output(datapr)
    	

	forms.p.controller.show()

In the field i put in the form, the data is not shown and i know there are records (the navigator shows there are records). Also i tried putting ‘test’ and ‘a’ to the dataprovider in the field but i have the same problem. How can i associate the field with the dataset i want to show???

Thank you

2

With convertToDataSet you can provide an array of names that will be used as the dataprovider names.

For example in your case:

var ds = databaseManager.convertToDataSet(a, ["tablename"]);
3

thank you, Joas, that did it… it was so easy jej…

Andres