Hi AllI have a table which has 2 recently added fields (COMMANDER_NAME and COMMANDER_EMAIL). I have verifed that these fields are visible in the 1) the Table itself 2) the related Stored Procedures 3) Object Mapper.
I assign customizations to these fields and run the mapper. The fields are then displayed as both properties and fields in the Field Enumeration for the related object.
When I run this object; however, these 2 fields are not being seen as part of the CurrentDataTable. When I view the CurrentDataTable, all of the other fields are there and work fine. I've tried clearing the setup in the Object Mapper and rebuilding to no avail. I then created a new object with a different name, remapped everything and deleted the original one. Unfortunately, The problem still persists.
Thanks!
[Browsable(false),
BusinessFieldDisplayInEditor(),
Description("COMMANDER_NAME"),
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
public System.String COMMANDER_NAME
{
get
{
object loValue;
loValue = this.CurrentRow["COMMANDER_NAME"];
if (loValue == DBNull.Value)
{
return String.Empty;
}
else
{
return ((System.String)loValue).Trim();
}
}
set
{
if (value != String.Empty)
{
this.CurrentRow["COMMANDER_NAME"] = value;
}
else
{
this.CurrentRow["COMMANDER_NAME"] = DBNull.Value;
}
}
}
public enum UserPrimaryProfileFieldNames
{
USER_PROFILE_ID,
USER_GUID,
USER_NAME_PID,
FIRST_NAME,
MI,
LAST_NAME,
SSN,
EMAIL,
ASSIGNED_ORGANIZATION_ID,
OFFICE_SYMBOL,
SERVICE_TYPE_ID,
COMMANDER_NAME,
COMMANDER_EMAIL,
FIRST_ADDED_DT,
LAST_UPDT_DT,
LAST_USER_ID,
ROW_VERSION,
CUSTOM_FIELD
}
Here is the actual table definition
CREATE TABLE [dbo].[ECAS_USER_PROFILE](
[USER_PROFILE_ID] [int] IDENTITY(1,1) NOT NULL,
[USER_GUID] [uniqueidentifier] NULL CONSTRAINT [DF_ECAS_USER_PROFILE_USER_GUID] DEFAULT (newid()),
[USER_NAME_PID] [nvarchar](256) NULL,
[FIRST_NAME] [varchar](50) NOT NULL,
[MI] [char](1) NULL,
[LAST_NAME] [varchar](50) NOT NULL,
[SSN] [char](9) NULL,
[EMAIL] [varchar](50) NULL,
[ASSIGNED_ORGANIZATION_ID] [int] NULL,
[OFFICE_SYMBOL] [varchar](50) NULL,
[SERVICE_TYPE_ID] [int] NULL,
[COMMANDER_NAME] [varchar](50) NULL,
[COMMANDER_EMAIL] [varchar](50) NULL,
[FIRST_ADDED_DT] [datetime] NOT NULL CONSTRAINT [DF_ECAS_USER_PROFILE_FIRST_ADDED_DT] DEFAULT (getdate()),
[LAST_UPDT_DT] [datetime] NOT NULL CONSTRAINT [DF_ECAS_USER_PROFILE_LAST_UPDT_DT] DEFAULT (getdate()),
[LAST_USER_ID] [nvarchar](256) NOT NULL,
[ROW_VERSION] [timestamp] NULL,