Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
2 Replies
3116 Tampilan

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


Avatar
Buang
Jawaban Terbai

Hi,
The SQL constraints do work while importing data.
Regards

Avatar
Buang
Jawaban Terbai

You can check importing with sample date.

I think import will fail due to constraint error. Once remove duplicate row, then only import success.

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
@api.constrains Diselesaikan
2
Des 23
3151
0
Jun 21
2588
1
Nov 20
4384
2
Mar 24
5550
1
Jul 23
1574