Wow... was integer :S
Thanks, now working perfectly :)
On Aug 21, 2:53 am, tomekM <[EMAIL PROTECTED]> wrote:
> For me it works :)
>
> D:\tmp>sqlite3 test.db
> SQLite version 3.5.6
> Enter ".help" for instructions
> sqlite> create table names (id integer primary key autoincrement, name text);
> sqlite> insert into names (name) values ('myname');
> sqlite> select * from names;
> 1|myname
> sqlite> insert into names (name) values ('other name');
> sqlite> select * from names;
> 1|myname
> 2|other name
> sqlite>
>
> The key here is: "integer primary key autoincrement"
>
> Regards,
> tomekM
>
>
>
>
>
> On Thu, Aug 21, 2008 at 6:01 AM, WalterCool <[EMAIL PROTECTED]> wrote:
>
> > On Aug 20, 10:01 pm, "Gary Bernhardt" <[EMAIL PROTECTED]>
> > wrote:
> >> You have to keep in mind that sqlite is not Postgres or Oracle; it
> >> serves a different purpose. :) Postgres is a good choice if you want
> >> those kinds of guarantees.
>
> > I know... but i dont want a service running for now, i have a flash
> > disk and i dont wanna kill it using that kind of daemons :P
>
> > On Aug 20, 10:08 pm, "Anand Chitipothu" <[EMAIL PROTECTED]> wrote:
> >> I think, you need to say:
>
> >> CREATE TABLE test(id int AUTOINCREMENT, name varchar[256],primary key(id));
>
> > Tried... but dont works in sqlite :(
>
> > Well, thanks, is a sqlite issue, now webpy ;) Thanks
>
> --
> If you had one shot, or one opportunity
> To seize everything you ever wanted - One moment
> Would you capture it or just let it slip?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web.py" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---