List:MySQL++« Previous MessageNext Message »
From:Bart Verstraete Date:March 2 2008 9:06pm
Subject:insert ssqls
View as plain text  
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
Thread
insert ssqlsBart Verstraete2 Mar
  • Re: insert ssqlsWarren Young4 Mar
Re: insert ssqlsWarren Young4 Mar
Re: insert ssqlsWarren Young4 Mar
  • v3.0.0Corin Fletcher5 Mar
Re: v3.0.0Warren Young5 Mar