Hi I'm trying with following struct

sql_create_7(wpkn31500, 1, 7, Date,date, Time,time, double,last, double,tradesize, double,volume, double,bid, double,ask)

to insert data via this code

wpkn31500 row; row.set("2003-12-15","110101", NoKey.GetLetzterKurs(), NoKey.GetLetzterUmsatz(), NoKey.GetGesamtUmsatz(), NoKey.GetNachfrage(), NoKey.GetAngebot()); query.insert(row); cout << "Querry:" << query.preview() << endl; query.execute();

} catch (BadQuery er){ // handle any connection // or query errors that may come up cerr << "Error: " << er.error << endl; nRetCode = -1;

} catch (BadConversion er) { // we still need to cache bad conversions incase something goes // wrong when the data is converted into stock cerr << "Error: Tried to convert \"" << er.data << "\" to a \"" << er.type_name << "\"." << endl; nRetCode = -1; }

But I'm getting this error:

Error: You have an error in your SQL syntax near ':01:01,..... !? Is there a problem with the time format or the : "

Further I want to use the mentioned structure/code ito insert values in a lot of different tables how can I achieve that the values won't be inserted in the table wpkn31500 instead int the table xyz, abc, def ....