Re: [web2py] Re: Virtual Fields and usual database's Views

2011-11-08 Thread BrendanC
The problem with using a view is that Web2py/Django/Rails is that they all expect a unique id field in the result set. If you create your views with a dummy id field you may be able to use it as a 'pseudo' table. However you still need to somehow populate that field with a unique value. Also u

Re: [web2py] Re: Virtual Fields and usual database's Views

2011-11-08 Thread Daniel Aguayo
2011/11/8 danto that was me, sorry > > 2011/11/8 BrendanC > >> Daniel, >> Not sure what you are asking, but this might help you: >> >> Virtual fields are otherwise known as 'computed columns' in database >> terms - if that is what you are familiar with. e.g. Sum, Count, Min, Max, >> etc

Re: [web2py] Re: Virtual Fields and usual database's Views

2011-11-08 Thread danto
2011/11/8 BrendanC > Daniel, > Not sure what you are asking, but this might help you: > > Virtual fields are otherwise known as 'computed columns' in database terms > - if that is what you are familiar with. e.g. Sum, Count, Min, Max, etc as > these values are derived from underlying table data i