Symptoms
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
Cause 1
The table in the error message is a custom table that does not have a time stamp column. See Resolution 1.
Cause 2
The 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
Resolution 1
All 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:
SP_HELP [tablename]
-- replace the tablename placeholder with the name of the table
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.
Resolution 2
Find 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:
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 %Note If the error message contains the earnded_aarg_ytd table, use the SQL statement to search for "earnded_%".
-
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.
-