Extracting DataSet from DataSet

Classic Servoy
1

Hi,

When one makes a ds thru a query it returns what u would expect:

[cname1, cname2]
data00 data01
data10 data11
data20 data21

Based on qry: SELECT cname1, cname2 FROM etc…

But for my purposee i want to use it in it2be data-plugin, like:

myIDExcelObject.update(inputFilePath, [outputFilename/header, header, [JSDataSet/IDFormattedDataSet dataset, [sheetIndex/sheetName, [x, [y]]]]]])

So, now i want the third argument (the ds) just PLAIN data to update the WorkBook, i.e without the columnnames "“cname1, cname2”

I tried to make a second ds from the ds_by_query i.e to strip the columnnames, but did not succeed
,(but maybe i should try it differently?)
Anyway: my aim is to use (it2be) update fcn to push the data only :!:

So i guess my question is twofold:
1 - Can i create a ds from a ds, just stripping the column heads ?
2 - How to use the update cmd above, to push ds-data to Workbook withouth column names ?

Any tips /ideas?

Thanks in advance
Kind regards, Jan

2

Getting a dataset from a SQL query doesn’t return column names in the first row typically. Can you post your code?