I think it should be VALUES IDENTITY_VAL_LOCAL() INTO :hostvar
but pyodbc does not support that. We could ask the developer to include it. Otherwise it could be something ugly as: cursor.execute("select distinct identity_val_local() from person").next ()[0] >>> Decimal("9") --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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 -~----------~----~----~----~------~----~------~--~---