Re: [SOCI-users] RFD: Adding functions for working with auto-incremented values

2012-05-28 Thread Vadim Zeitlin
On Mon, 28 May 2012 10:29:06 -0700 Pawel Aleksander Fedorynski pfe...@gmail.com wrote: PAF  I also wonder where should the new methods be documented. The easy way is PAF to just do it in the reference section, but nobody is probably going to PAF find them there. But I don't see where else to

Re: [SOCI-users] RFD: Adding functions for working with auto-incremented values

2012-05-27 Thread Pawel Aleksander Fedorynski
This has been discussed several times on soci-users: http://sourceforge.net/mailarchive/message.php?msg_id=21455333 (search for sequence) http://sourceforge.net/mailarchive/message.php?msg_id=21032224 http://sourceforge.net/mailarchive/message.php?msg_id=24476114 Long story short, there was

[SOCI-users] RFD: Adding functions for working with auto-incremented values

2012-05-25 Thread Vadim Zeitlin
Hello, It is common to use auto-generated values for primary keys of the tables that don't have any natural candidate. There are 2 mechanisms for doing this depending on the database: 1. Use a sequence. In this case you need to get the next value from the sequence and use it in INSERT INTO