Hello,
I try to install a SQLite Database through an msi package and to execute a SQL Script to modify the DB. I created a DB Connection to the SQLite DB file and a script. But I get a Syntax Error message when installing the package and I don't get why...
I try to replace some DB entries with new values, for example:
UPDATE MEDICS_InformationSystemConfigurations SET Serialisation = replace( Serialisation, 'ECRepositoryVariable', 'RepositoryVariable');
This statement works fine when I open the DB for example with "DB Browser for SQLite" but it doesn't work within the MSI package. Do I have to add some more information to the SQL script?
Thank you!
Marian