Bad Extra Values¶

This script runs from the Main Menu if added to the Menu. It shows any corrupt ExtraValues in the database for People records.

The comment at the top of the script ensures that this report can only be run by an Admin user.

The recommended name is BadExtraValues

Use the following code to Create the SQL Script.

See How to create a SQL Script for help in creating a new script.

--roles=Admin
SELECT PeopleId ,
       '''' + Field + '''' ,
       StrValue ,
       DateValue ,
       TransactionTime ,
       Data ,
       IntValue ,
       IntValue2 ,
       BitValue ,
       FieldValue ,
       Type
FROM dbo.PeopleExtra
WHERE Type NOT IN ('Code', 'Int', 'Date', 'Text', 'Bit', 'Data')
or Field like '% '
ORDER BY Field