Jiwa

In using the new Jiwa database bacpac file to directly create a database through SQL management studio under SQL 2019, due to the issues with SQL 2019 I am getting and error about Currency Record not found at login, what would I have to run under SQL to fix this?

SBarnes wrote:In using the new Jiwa database bacpac file to directly create a database through SQL management studio under SQL 2019, due to the issues with SQL 2019 I am getting and error about Currency Record not found at login, what would I have to run under SQL to fix this?

Code: Select all

UPDATE FX_Currency SET IsLocal = 1 WHERE ShortName = 'AUD'

Obviously change the code from 'AUD' to something else if you're not using AUD as the local currency.

Thanks Mike,

that fixed it.