When you open a screen in Microsoft Dynamics SL 7.0, in Microsoft Dynamics SL 6.5, or in Microsoft Business Solutions - Solomon 6.0, you may receive the following error message:
Programming Bulletproof Error 10260 - Table % does not have a TimeStamp Column, please add a TimeStamp Column to the table.The table name in the error message may not be the name of an actual table in the database.
Cause 1The table in the error message is a custom table that does not have a time stamp column. See Resolution 1.
Cause 2The table in the error message is not actually a table in the database or is a table that already has a time stamp column. In this case, another table in the database may share the first 8 characters of the table name in the error message. See Resolution 2.
Resolution 1All tables that are used in Microsoft Dynamics SL screens must have a time stamp column. To verify that the table has a time stamp column, run the following statement in SQL Server Management Studio or in SQL Query Analyzer:
This statement returns a list of all columns in the table together with the column type. One of the columns must have a column type of timestamp.
-- replace the tablename placeholder with the name of the table
Resolution 2Find the table that shares the first 8 characters of the table name in the error message. To do this, follow these steps:
- Run the following statement in SQL Server Management Studio or in SQL Query Analyzer against the Microsoft Dynamics SL application database to find any tables that share the same first 8 characters of the table name in the error message: Note If the error message contains the earnded_aarg_ytd table, use the SQL statement to search for "earnded_%".
select name from sysobjects where type='U' and name like '12345678%'
-- replace the 12345678 placeholder with the first 8 characters of the table name referenced in the error
-- do not replace the %
- If the statement returns a table name, rename this table so that the table name does not share the same first 8 characters.
Note If the statement returns "EarnDed_Backup," you must rename the EarnDed_Backup table to something like "Backup_EarnDed". To do this, follow these steps:
- In the Object Browser in SQL Server Management Studio or in the Object Browser in SQL Query Analyzer, expand the Microsoft Dynamics SL application database.
- Expand Tables.
- Locate the table name from step 1.
- Right-click the table, and then click Rename.
- Type the new table name, and then click OK.