11-02-2016 07:16 AM
I found the defaultvalue in the SQL table TBL_SYSCOLUMN
select * from TBL_SYSCOLUMN where DEFAULTVALUE='thevalue'
So you may find the informaiton. But I am not able to change the value with an SQL update command:
update TBL_SYSCOLUMN set DEFAULTVALUE='Deutschland' where COLUMNID='399AE90F-B869-4711-965A-6EF96C82AC81'
Results with error:
Column 'BUSINESS_COUNTRYNAME' in table 'TBL_CONTACT' is invalid for creating a default constraint. Meldung 1750, Ebene 16, Status 0, Zeile 2 Could not create constraint or index. See previous errors.
11-10-2016 09:02 AM
11-21-2016 03:50 AM
02-10-2017 07:01 AM
It was converted from V18. We have only had act for about 5 months now. Still in the implementation phase of things and I know this will be a large annoyance once it rolls out to the rest of the company.
02-10-2017 08:12 AM
This defect is still currently outstanding. If you have a value stuck in the Country default value field, we can attempt to remove the value for you, however we can't guarantee it will be possible. This would require you sending over your database to our database services team.
Give us call on 866 873 2006 and speak to a technician who will be able to get the process started.