I am basing that insert statement on the one setup by the wizard.
All the examples I have seen use the question marks in the value clause of the SQL.

I am also creating the select clause myself (because I need data from multiple tables), not extracting the entire table into the dataset.

If I add parameters to the parameter collection for the insert command object, I dont get the error, but the database is not updated at all.

Only if I hard code the values in the SQL statement manually does it do anything. Surely that defeats the purpose of the .NET dataAdapter functions?
BG