Currency SQL 2019 Error

[SBarnes]

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?

[Mike.Sheen]

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.

[SBarnes]

Thanks Mike,

that fixed it.