Why do I receive a 'General error' when trying to use INSERT with Database Toolbox 3.0 (R14)?

Question

MathWorks Support Team 2009-6-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/98203-why-do-i-receive-a-general-error-when-trying-to-use-insert-with-database-toolbox-3-0-r14

I am using INSERT to add a row to one of the tables in a database. This works the first time I call INSERT, but subsequent calls result in an error message. For example, my first call is:

insert(conn,'productTable',{'productNumber','unitCost'},{1004,3.45});

This call works, but subsequent calls to INSERT result in the following error:

 ??? Error using ==> database.insert
 General error

请先登录，再回答此问题。

Answer 1

MathWorks Support Team 2009-6-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/98203-why-do-i-receive-a-general-error-when-trying-to-use-insert-with-database-toolbox-3-0-r14#answer_107553

This error results when the database has a primary key and you try to insert a row with a non-unique primary key. A primary key is a unique identifier in a table and prevents a row from being inserted that has the same primary key value as another row. A primary key can include values from one or more fields. When you try to add a row with a value in the primary key field that is the same as an existing value in a primary key field, the insert fails and an error appears.