Re: [web2py] capturing primary key during insert

2016-10-05 Thread Alex Glaros
yes return of primery key works. First time it didn't work but changed code and it does work. Sorry guys, tried to delete my post after it tested correctly but too late. Lack of sleep made me miss the solution. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] capturing primary key during insert

2016-10-05 Thread Richard Vézina
id = db.SuperObject.insert(**db.SuperObject._filter_fields(form.vars)) Should work, does it? Richard On Tue, Oct 4, 2016 at 5:42 PM, Alex Glaros wrote: > In doing a direct programatic insert without a form such as > db.SuperObject.insert(person_name = "Alex") > > is

[web2py] capturing primary key during insert

2016-10-04 Thread Alex Glaros
In doing a direct programatic insert without a form such as db.SuperObject.insert(person_name = "Alex") is there a way to capture the primary key during the insert as can be done in a form: super_object_fk = db.SuperObject.insert(**db.SuperObject._filter_fields(form.vars)) ? or do I have to

Re: [web2py] capturing primary key during insert

2016-10-04 Thread Marlysson Silva
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#insert Em terça-feira, 4 de outubro de 2016 00:53:58 UTC-3, Kiran Subbaraman escreveu: > > This may be what you are looking for: >

Re: [web2py] capturing primary key during insert

2016-10-04 Thread Marlysson Silva
The documentation call this: >>> db.person.insert(name="Alex")1>>> db.person.insert(name="Bob")2 *Insert returns the unique "id" value of each record inserted.* Most likely return id field like primary key Em terça-feira, 4 de outubro de 2016 00:53:58 UTC-3, Kiran Subbaraman escreveu: > >

Re: [web2py] capturing primary key during insert

2016-10-03 Thread Kiran Subbaraman
This may be what you are looking for: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=before_insert#callbacks-on-record-insert-delete-and-update Kiran Subbaraman http://subbaraman.wordpress.com/about/ On Tue,

[web2py] capturing primary key during insert

2016-10-03 Thread Alex Glaros
In doing a direct programatic insert without a form such as db.SuperObject.insert(person_name = "Alex") is there a way to capture the primary key during the insert as can be done in a form: super_object_fk = db.SuperObject.insert(**db.SuperObject._filter_fields(form.vars)) ? or do I have to