I have the following:
sql_create_19(lf_invoice,
1, 0,
mysqlpp::sql_bigint, id,
mysqlpp::Null<mysqlpp::sql_bigint>, contact_id,
mysqlpp::sql_date, invoice_date,
mysqlpp::Null<mysqlpp::sql_varchar>, vatId,
mysqlpp::Null<mysqlpp::sql_varchar>, title,
mysqlpp::Null<mysqlpp::sql_varchar>, first_name,
mysqlpp::Null<mysqlpp::sql_varchar>, last_name,
mysqlpp::Null<mysqlpp::sql_varchar>, companyname,
mysqlpp::Null<mysqlpp::sql_varchar>, street,
mysqlpp::Null<mysqlpp::sql_varchar>, housenumber,
mysqlpp::Null<mysqlpp::sql_varchar>, mailbox,
mysqlpp::Null<mysqlpp::sql_varchar>, zip,
mysqlpp::Null<mysqlpp::sql_varchar>, town,
mysqlpp::Null<mysqlpp::sql_varchar>, state,
mysqlpp::Null<mysqlpp::sql_varchar>, country,
mysqlpp::sql_float, vat_tarrif,
mysqlpp::sql_decimal, vat,
mysqlpp::sql_decimal, total_excl_vat,
mysqlpp::sql_decimal, total_incl_vat)
How do I insert a new row as 'id' is a auto_increment?
Using mysql++ 3.0
Grts Bart