|
|
|
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'
