creating new row returns wrong row by using SQLite as database
creating new row returns wrong row by using SQLite as database
junghyun0412
Posts: 1Questions: 0Answers: 0
in Editor
I'm using Editor 1.4.2, SQLite DB and .NET framework.
Everything seems working as expected except creating row.
When I creating new row, it creates new row correctly in the database, but it always returns (response) lowest id row and creates duplicate entry on DataTables.
Refreshing the page fixes duplicate row and insert newly entered row because new row was inserted to database correctly.
Has anyone experienced similar problem like this?
P.S.: I tested same code with SQL Server and it runs fine without this issue.
This discussion has been closed.
Replies
Hi,
I've just replied to your e-mail question about this as well, but for completeness I'll add a reply here - happy to continue the discussion here or by e-mail.
Does your SQLite database table contain an auto incrementing primary key value. If not, that is probably the issue. Otherwise, if you could post your table schema that would be useful so I can try to reproduce the error.
Allan