Hello,

we are using sqlite 3.12.1 on Android device and we are tring to copy 
content of the one table into another table using

INSERT OR REPLACE INTO <dst_table> SELECT * FROM <src_table>

This commad will fail on Android with error code SQLITE_CANTOPEN when
   - <dst_table> has any triggers configured (also empty one like 
"select 1" )
   - and the amount of row to be inserted is larger (currently it fails 
if it's 9226 rows but not with 9225 rows)

the same code works perfectly on Windows or Mac OS o iOS, when we 
dropped the trigger it works also perfectly on Android ?

Any hints ?

Martin

Reply via email to