I do not know. This may work. The "id" field does not be to be auto increment (it is not on GAE) but it needs to be integer (is that the case here?) You say you use a function to insert records. If this is a just implemented as a trigger executed on "INSERT" then fine else you will have to wait for new DAL to override DAL.INSERT
Massimo On Jul 23, 6:58 am, Fran <[email protected]> wrote: > On Jul 23, 12:47 pm, gillengam <[email protected]> wrote: > > > Book pag.143 - Legacy Databases paragraph > > In my database Oracle I have a table with a field called 'id' (primary > > key), > > but 'id' is type PREF0001, PREF0002, PREF0003, ....... > > I use a function to insert new record. > > Is this a problem for WEB2PY? Or must I add auto-increment integer > > field? > > I hope no. > > Until the new DAL is released, I believe that the id key needs to be > auto-increment integer, sorry. > > > Other question: can I query an Oracle view (I can access it read only, > > I cannot modify it and it has not auto-increment integer field 'id') > > The same answer, I believe. > > F --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
