The following code works;

 SQLEXEC(gnConnHandle,"INSERT into essStationData (cfgStationID,essNTCIPTimeStamp,essPrecipSituation,essPrecipYesNo,essPrecipitationEndTime,essPrecipitationStartTime,essVisibilitySituation,essWindSituation) values (?_station.cfgStationID,?timestamp,?v1,?v2,?v3,?v4,?v5,?v6)")

but if I try to pass the column names from variables thusly;

SQLEXEC(gnConnHandle,"INSERT into ?rwTable (cfgStationID,essNTCIPTimeStamp,?f1,?f2,?f3,?f4,?f5,?f6,?f7,?f8) values (?_station.cfgStationID,?timestamp,?v1,?v2,?v3,?v4,?v5,?v6,?v7,?v8)")

I get an error from the ODBC driver. My problem is that I have a variable set of columns that I need to operate on, so need to somehow virtualize the column names.

Is there a better way to do this?

TIA