Any ideas what can cause this error ? or is it an SC bug ? [TABLE=“class: scFormErrorTable, align: center”]
[TR]
[TD] [/TD]
[TD=“class: scFormErrorTitle, align: left”] [TABLE=“width: 0”]
[TR]
[TD=“class: scFormErrorTitleFont”]Error[/TD]
[TD]
[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[TR]
[TD=“class: scFormErrorMessage, align: center”]Error inserting - Unique key violation: CompanyName[/TD]
[/TR]
[/TABLE]
I have a Company table with one primary key as unique. The NAME field is regular VARCHAR(80)
To avoid duplicate records I set the unique parameter in the form on the NAME
Despite I enter new name into the form which I’m sure does not exist, the APP reports an error when saving !
any clues ?