Do they have an autoincrement integer field, even if not called id? what database?
On Nov 13, 1:31 pm, Brian M <bmere...@gmail.com> wrote: > Is there a way to work with database views using the DAL? I've got a > bunch of views in my database that handle common queries, but I'm not > seeing a way to use them with the DAL since they don't have an id > field. I tried to define a DAL "table" with the same fields as the > view and just set it to migrate=False, since I don't want the table to > be created, but from the Admin every query against the view is an > "Invalid Query". Is db.executesql() the only option? > > ~Brian --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---