how can I get the type of an unstored calc

Is there any way to write code to figure out the type of an unstored calc? I can provide the name of the server, the table name and the calc name.

JSColumn.getType() doesn’t help in this case because I’m not dealing with a db column.

The reason I need it is this: I am using Harjo’s createExportFile method and I’d like to add code to format columns based on their type. This is especially important on DATETIME data. But if the column is an unstored calc I can’t figure out its type.

If this capability doesn’t exist, I think it would be a good thing to add.

Thanks.

You can use something like:

solutionModel.getDataSourceNode("datasource").getCalculation("myCalculation").variableType

This is from Servoy 6.0.x upwards.

Regards,
Andrei