Topic: PRAGMA instruction on attached database
Hello Dmitry,
For upgrading purposes of databases generated by MVD, I need to set
SQLExecute('PRAGMA foreign_keys=OFF');
and then return the foreign key constraints back to normal with
SQLExecute('PRAGMA foreign_keys=ON');
This works on the main MVD database (the one attached by default), but if I attach a second database name (for example) OLD_DB, how do I run that query specifying it should impact the attached database and not the default one ?
Thanks in advance
Cheers
Mathias
Each time I get a divorce, I keep the house
Zaza Gabor