Missing Fields From CurrentDataTable

choyt — Fri, 19 Oct 2007 08:59:47 GMT

Hi All

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

[codesnippet]        [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;
                }
            }
        }[/codesnippet]

[codesnippet]        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
        }[/codesnippet]

Here is the actual table definition

[codesnippet]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,[/codesnippet]

RE: Missing Fields From CurrentDataTable

Trent L. Taylor — Fri, 19 Oct 2007 08:59:47 GMT

Great, sorry for the delayed response, glad you found it :)

RE: Missing Fields From CurrentDataTable

choyt — Thu, 18 Oct 2007 07:16:26 GMT

I found the issue...I had several sprocs that I had updated but missed one.

StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Missing Fields From CurrentDataTable

Missing Fields From CurrentDataTable

RE: Missing Fields From CurrentDataTable

RE: Missing Fields From CurrentDataTable