I need to add sql constraint so that it prevent the duplication in customer name.The sql constraint cannot be added to the existing module as it cannot be edited.So a new module has to be created.How to create this module and how to inherit the features in my new module and add the new features. ?
You can add the following code in your module to apply unique constraint for Customer :
class res_partner(osv.osv): _inherit = 'res.partner' _sql_constraints = [ ('name_uniq', 'unique(name)', 'Customer Name must be unique!'), ]
Before installing the module, make sure that existing customers don't have duplicate names. If exists, rename those Customers, else constraints will not be applied.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/23/14, 9:43 AM|
|Seen: 1367 times|
|Last updated: 3/16/15, 8:10 AM|