SQLObject

On Wed, Jun 20, 2007 at 01:51:56PM -0300, Leandro Melo de Sales wrote:
>   I want to use the internel sqloject self.id to identify a specific
> object. I want to change the start value to 0, not to 1. In this well
> I can do MyClass.get(0) as the first database Item. How can I change
> the start value to 0, instand of 1.

   Autoincrement is performed by DB, not SQLObject. In Postgres one can
manipulate the sequence that is used for autoincremented id.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            phd@...
           Programmers don't die, they just GOSUB without RETURN.

I'm using SQLLIte. How can I manipulate the autoincrement for this
database by using sqlobject.

Thanks,
Leandro.

2007/6/20, Oleg Broytmann <phd@...>:
> On Wed, Jun 20, 2007 at 01:51:56PM -0300, Leandro Melo de Sales wrote:
> >   I want to use the internel sqloject self.id to identify a specific
> > object. I want to change the start value to 0, not to 1. In this well
> > I can do MyClass.get(0) as the first database Item. How can I change
> > the start value to 0, instand of 1.
>
>    Autoincrement is performed by DB, not SQLObject. In Postgres one can
> manipulate the sequence that is used for autoincremented id.
>
> Oleg.
> --
>      Oleg Broytmann            http://phd.pp.ru/            phd@...
>            Programmers don't die, they just GOSUB without RETURN.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sqlobject-discuss mailing list
> sqlobject-discuss@...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>


-- 
Leandro Melo de Sales.
Pervasive and Embedded Computing Laboratory
http://embedded.ufcg.edu.br/
+55 083 3310-1404 (extension 208)

"There are 10 types of people in this world: those who understand
binary, those who don't"

On Wed, Jun 20, 2007 at 02:45:14PM -0300, Leandro Melo de Sales wrote:
> I'm using SQLLIte. How can I manipulate the autoincrement for this
> database by using sqlobject.

   You cannot. SQLite doesn't have a proper autoincrement, and the builtin
default for the first value is always 1: http://www.sqlite.org/faq.html#q1

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            phd@...
           Programmers don't die, they just GOSUB without RETURN.

Thank you!

Leandro.

2007/6/20, Oleg Broytmann <phd@...>:
> On Wed, Jun 20, 2007 at 02:45:14PM -0300, Leandro Melo de Sales wrote:
> > I'm using SQLLIte. How can I manipulate the autoincrement for this
> > database by using sqlobject.
>
>    You cannot. SQLite doesn't have a proper autoincrement, and the builtin
> default for the first value is always 1: http://www.sqlite.org/faq.html#q1
>
> Oleg.
> --
>      Oleg Broytmann            http://phd.pp.ru/            phd@...
>            Programmers don't die, they just GOSUB without RETURN.
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> sqlobject-discuss mailing list
> sqlobject-discuss@...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>