They are SQLite views, though I suspect you'd have similar problems with other database's views as well.
There is no auto-increment field at all - it's a database view rather than a table. Having an auto-increment field doesn't make any sense in a view, you're not going to insert any records into a view. These are views that do things like summarize data from multiple tables. ~Brian On Nov 13, 1:44 pm, mdipierro <[email protected]> wrote: > Do they have an autoincrement integer field, even if not called id? > what database? > > On Nov 13, 1:31 pm, Brian M <[email protected]> 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
