>> In the middle of all that, after the line >> CREATE INDEX idx_Appointment_SaleItemUUID ON Appointment >> (Appointment_SaleItemUUID); >> is some slightly odd output - that's just as it appears in the command line >> output in Terminal on my Mac. > What does "PRAGMA integrity_check;" say about your database file? On that file it says the database is malformed. So, I?ve gone back to an earlier version of the file, with all of my tables in, rather than the cut-down version I was testing things on and for which I posted the .fullschema before
On this earlier version, .fullschema still has some odd code which looks like chopped around trigger code in it (BEGIN INSET SaleCalc_PaiWHERE TxnCalc_ ? etc, and BEGIN UPSET TxnCalcUnallocatedSWHERE TxnAllocation_SaleUUID?, amongst others) but the triggers run just fine whenever I do the relevant inserts. The integrity checks in both the fast and slow state on this database both say ?ok?. Hamish
