Kevin,
I'd say using a cursor/table is a lot more effort than just working out the details of how you need to convert each datatype to an appropriate value for an SPT statement. You can write your own little SQLTransform() udf and put a case in there for each datatype.
The problem calling the method with the ? is caused by the effective LPARAMETERS local defintion of the parameters which hides it from the SQLExec wrapper method.
Datetimes need to be sent to SQL Server as quoted strings ala '10/31/2005 11:50:09'
>Thanks for your reply. I origianlly tried to do it this way, but I had trouble
>getting it right.
>
>Sergey and Cetin both suggested using a table, so I went with that.
>
>I would have preffered to build a string, but the table idea works.