Re: [web2py] Re: record versioning

2015-12-01 Thread Fabiano Almeida
thanks! 2015-12-01 17:21 GMT-02:00 Anthony : > web2py does not support the SQL UNION statement, but you can separately > query the two tables and generate the union of the two Rows objects via > Python: > > all_records = db(db.mytable).select() | db(db.mytable_archive).select() > > See > http://w

Re: [web2py] Re: Record Versioning

2012-01-19 Thread JF
No, I'm simply playing with SQLite. It's only for evaluation only. Anyway, I also noticed that it would store a new record regardless there is a modification in a field or not. Is it normal? Is there a way to avoid storing new record if in the end there is no difference when compared to prev

Re: [web2py] Re: Record Versioning

2011-12-28 Thread Khalil KHAMLICHI
If you are using mysql db, you can try to use triggers instead of all of this.