Hi, Pierre -

The problem is the "save as" function operates on the contents of the DataWindow's primary buffer, not on the various column DWObjects which may or may not have been created in the DataWindow Painter. The reason why the "Modify(destroy column..." approach does not accomplish what you are wanting to do is because Destroy column affects only the DWObjects...not the column definitions in the primary buffer. As far as I know, there is no way to remove columns from the primary buffer at execution time.

The only way I know this might possibly be done would be to dynamically create from syntax an external source DataWindow that contains all of the column definitions you want, in the order you want them, with the headings you want, and use that in a DataStore. Then you would have to copy the data from your "source" DW/DS into the "save as" DS, either cell by cell or perhaps one column at a time using dot notation. The datatypes on the column definitions would have to match for this to work. Note that this would essentially duplicate the amount of data kept in memory - which could have implications for very large datasets.

Best regards, John

Hi Pierre;

  Have you tried ...

<DC/DS>.Modify( "destroy <Columnname>")

Regards .. Chris