Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
hello guys. i want to ask some questions about SQL constraints when importing data in odoo
let's say i have 1 field (name) and I've added SQL constraints unique to that field.. what happens if we importing 2 rows with the same name?
for example:
rows 1: test123
rows 2: test123
do the validation sql constraints pop up shows or we keep importing the data but only the last row (row 2)? thanks
Hi,
The SQL constraints do work while importing data.
Regards
You can check importing with sample date.
I think import will fail due to constraint error. Once remove duplicate row, then only import success.
Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!
Rekisteröidy| Aiheeseen liittyviä artikkeleita | Vastaukset | Näkymät | Toimenpide | |
|---|---|---|---|---|
|
@api.constrains
Ratkaistu
|
|
2
jouluk. 23
|
3205 | |
|
0
kesäk. 21
|
2613 | ||
|
1
marrask. 20
|
4400 | ||
|
_sql_constraints fail to be effective
Ratkaistu
|
|
2
maalisk. 24
|
5610 | |
|
1
heinäk. 23
|
1606 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
