Data insertion failing without 'id' PK
mumincelal opened this issue · 1 comments
mumincelal commented
if id
PK is not specified explicitly in the database, data insertion is failing and sqb is returning Unable to insert new row
.
Database structure that causing insertion problem
When I debug the code marked as 1 and as 2 code lines the following picture is returning undefined.
Converted database structure that not causing insertion problem
if id
is inserted into the database structure then like the above picture then marked as 1 and as 2 code lines are not returning undefined (returning id
) and insertion completed successfully.
erayhanoglu commented
It seems your table has no primary key. So SQB can not fetch row after insert. If you add a primary key to your table it will work as expected.