Archive Issue with Computed Columns

From TrialWorks Wiki
Jump to: navigation, search

A very common problem with the archive prior to ArchiveSQL.dll version 1.80.1069 was the error listed below. To fix simply install the new ArchiveSQL.dll version 1.8.1070 available from our FTP ftp://files.trialworks.com/TrialWorks%20SQL/ArchiveSQL/ArchiveSQL_1.8.0.1070.zip

10/28/2009 | 8:07:35 AM | Errors reported during insert on Expense: [SQL-DMO][Microsoft][ODBC SQL Server Driver][SQL Server]The column "AmountDue" cannot be modified because it is either a computed column or is the result of a UNION operator.