Jean-François RIGHI wrote:
> 1) We were working with an old version of System.data.sqlite.dll (1.0.66)
> wich was prety stable. But we needed to work with concat index (CREATE
> INDEX IDX ON TABLE_1 (FIELD1 || FIELD2) to upgrade performance. Since we
> changed the dll we often got a Database base disk is malformed issue. We
> can repair the base via an sql dump of the base. The issue itself is never
> exactly the same : we can have a duplicate TRIGGER or TABLE or sometimes
> INSERT INTO with non valide data.
Are you able to share the full schema for the database?
Joe Mistachkin @ https://urn.to/r/mistachkin
sqlite-users mailing list