From: Warren Young
Date: March 4 2008 3:11am
Subject: Re: insert ssqls
List-Archive: http://lists.mysql.com/plusplus/7494
Message-Id: <47CCBDF0.9090904@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.