fix for primary key result by replaced the SELECT next sequence value with RETURN

[vidur]

This issue is happening with the AutoIncrement column. The problem was new record is getting saved to DB and the object doesn't have a primary key set after a successful transaction. I've made it so the object would set the DB's primary key set after the transaction complete.