Página 1 de 1
Sqlite Error : Interrupted [#9]
Publicado: Vie Nov 14, 2014 6:31 am
por Milan Mehta
Quite often while doing Database Operation in Sqlite we come across this error - interruped [#9] and transaction is rolled back. But however if we do the same operation in Sqlite studio or similar workbench we do not face this problem.
Is there any way to resolve the issue ?
TIA
Milan.
Sqlite Error : Interrupted [#9]
Publicado: Vie Nov 14, 2014 10:19 am
por ignacio
Milan Mehta escribió el vie, 14 noviembre 2014 06:31Quite often while doing Database Operation in Sqlite we come across this error - interruped [#9] and transaction is rolled back. But however if we do the same operation in Sqlite studio or similar workbench we do not face this problem.
Is there any way to resolve the issue ?
TIA
Milan.
I personally never had that error. Please try to make a SMALL sample to reproduce it. BTW I suggest two things:
1) ALWAYS use Begin-End transaction commands
2) For read-only 'select' statements use a memory recordset. Then all the order and filter operations are done internally with no SQLite intervention.
Regards,