Write to a BasicStreamingDataset?

I’m running a select query using system.db.runNamedQuery.

The query returns several records, each record has 8 columns / fields

results = system.db.runNamedQuery("PathTo/SelectQuery")

the data type of results is BasicStreamingDataset

My question is . . Is it possible to assign values to 1 field in each record of the BasicStreamingDataset?

I want to loop through results, calculate a value, and assign the value to a field in results?

Datasets are immutable. You’ll have to build a new dataset as you iterate through the results, or really start building new header and data lists that you can use to construct a dataset via system.dataset.toDataSet.

2 Likes