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 :doc:`../CreateSqlScript` for help in creating a new script.

.. code-block:: sql

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