should we consider this a bug and use SELECT SCOPE_INDETITY()
? On Jun 27, 9:39 am, Jose <jjac...@gmail.com> wrote: > On 27 jun, 09:42, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > Those errors are fine. request.vars.id is a Reference field to the > > newly created record. It can be converted to int and treated as a int > > but it is not a int. response.flash should be a string or a helper. If > > you pass a Reference without converting to int, it will cause the > > problems below. > > > The trigger must be creating some problem. It may be it interferes > > with the machanism used by web2py to get the id of the last inserted > > record. > > Perhaps the trigger is really affecting the way you get the ID. > > Please see this [1] and [2]. Web2py use "SELECT @@IDENTITY;" to get > the id. > > In my case, the trigger does not do an insert into another table, but > it makes an update in another table. Then the problem that is > mentioned in the links that showed not apply. > > Jose > > [1]http://msdn.microsoft.com/en-us/library/ms190315.aspx > [2]http://cgaskell.wordpress.com/2006/11/15/using-identity-vs-scope_iden...