List:MySQL++« Previous MessageNext Message »
From:Warren Young Date:March 4 2008 3:11am
Subject:Re: insert ssqls
View as plain text  
Bart Verstraete wrote:
> I have the following:
> 
> sql_create_19(lf_invoice,
>    1, 0,
>    mysqlpp::sql_bigint, id,

[snip]

> How do I insert a new row as 'id' is a auto_increment?

The only easy way is to remove the 'id' member from the structure.  This 
means you will need two versions of this structure if you also use it 
for data retrieval.  Or, you can do as I do, and hand-roll your INSERT 
and UPDATE queries, using the SSQLS only for data retrieval.

This weakness will be easy to fix in SSQLSv2, so I'm not motivated to 
fix it before then.
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