Product Documentation

c-treeACE V10.0 Release Notes

Previous Topic

Next Topic

Corrected Scale Value for c-treeACE SQL MONEY Types

c-treeACE SQL MONEY types should always have a fixed scale of 2. However, it was found that it was possible for this value to be set to 0. The default value of 2 is now correctly forced in all circumstances. An immediate field fix for existing databases that may exhibit this incorrect value is to execute an update statement on the system table:

UPDATE admin.syscolumns SET SCALE = 2 WHERE coltype = 'MONEY'

TOCIndex