On 15 jun, 05:12, Sky <hmonfa...@gmail.com> wrote: > Thank you Jose, > but I couldn't find out if you used define_table or not? > can you drop me a piece of your code? > i get 'invalid query' error when i query on my views. >
They are declared in the same way that a real table. Then you can create queries, use them to link to other tables, etc. In my specific case, no insert or update records, but if your database engine accepts, there would be drawbacks. One more thing, the view does not necessarily have to contain fields for a single table, but can have as many joins as you like, that use is transparent. Jose
