Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I get concurrency error when modifying records using SQLiteDataAdapter or SQLiteDataTable. What can be wrong?

April 26, 2017Concurrency Error modifying records wrong

0

Posted

I get concurrency error when modifying records using SQLiteDataAdapter or SQLiteDataTable. What can be wrong?

1 Answer

0

Posted

This can happen when SQLiteCommandBuilder generates a query without primary key field. To avoid it use custom update command instead of generated by SQLiteCommandBuilder. This problem should not take place if primary key field participates in SELECT statement. • No components can be found in the toolbox. This can happen if the installation encountered some problems. You can add the components to toolbox manually. This procedure is described in the Installation article in the documentation. Note that Microsoft Web Developer 2005 Express edition does not allow working with toolbox at all. • dotConnect for SQLite components in Visual Studio 2005 are grey… Make sure you’re in Component Designer view. Do not confuse with Designer view. To switch between views use context menu of .aspx file in Solution Explorer. This relates to Web projects only. • SQL Server Integration Service (SSIS) can’t get the list of tables in my SQLite database. This is an architecture limitation from Microsoft, SS