Creating a new Jiwa database where Australian Dollar is not the local currencies sets both as Local

Problem

Creating a new Jiwa database and selecting any currency other than Australian Dollar, sets both currencies as Local. Attempting to correct this in the application errors.

Solution

SQL skills are required

Sound SQL knowledge is required to complete this task

This situation can only be corrected via SQL

Select the records from the FX_Currency table
Update the field IsLocal for the currency that is NOT the local currency e.g. Australian Dollar
update FX_Currency set IsLocal = '0' where RecID = 'AAC8BD6A-A686-40C8-B052-EF4AF089E699'

Problem

Solution

SQL skills are required

Related articles