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
-~----------~----~----~----~------~----~------~--~---
