Command #: 1
Timestamp: 2007-01-25 09:10:28.64
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: INSERT INTO [dbo].[IncdType] ([SQLGUID], [Dept], [EventNo], [DescText], [PathOf], [HeaderDetail], [ExcludeCaseMgt], [SymbolName], [FName], [FSize], [FColor], [FStyle], [FCharSet], [FIndex], [SOP], [SQLRegionID], [SQLLastUpdated], [SQLIPAddress], [SQLEmployeeID]) VALUES (@SQLGUID, @Dept, @EventNo, @DescText, @PathOf, @HeaderDetail, @ExcludeCaseMgt, @SymbolName, @FName, @FSize, @FColor, @FStyle, @FCharSet, @FIndex, @SOP, @SQLRegionID, @SQLLastUpdated, @SQLIPAddress, @SQLEmployeeID);
Command Parameters
@SQLGUID: 'a5d320f5-f88e-42e3-be6a-5a138ad5d69a' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: 'TESTABC' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: 'TESTABC' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: '' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: '' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/1/1800 12:00:00 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: '' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
Command #: 2
Timestamp: 2007-01-25 09:10:33.486
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: UPDATE [dbo].[IncdType] SET [SQLGUID] = @SQLGUID, [Dept] = @Dept, [EventNo] = @EventNo, [DescText] = @DescText, [PathOf] = @PathOf, [HeaderDetail] = @HeaderDetail, [ExcludeCaseMgt] = @ExcludeCaseMgt, [SymbolName] = @SymbolName, [FName] = @FName, [FSize] = @FSize, [FColor] = @FColor, [FStyle] = @FStyle, [FCharSet] = @FCharSet, [FIndex] = @FIndex, [SOP] = @SOP, [SQLRegionID] = @SQLRegionID, [SQLLastUpdated] = @SQLLastUpdated, [SQLIPAddress] = @SQLIPAddress, [SQLEmployeeID] = @SQLEmployeeID WHERE [SQLGUID] = @SQLGUID_ORGPK AND (([SQLGUID] = @SQLGUID_ORG) OR ((@SQLGUID_ORG IS NULL) AND ([SQLGUID] IS NULL))) AND (([Dept] = @Dept_ORG) OR ((@Dept_ORG IS NULL) AND ([Dept] IS NULL))) AND (([EventNo] = @EventNo_ORG) OR ((@EventNo_ORG IS NULL) AND ([EventNo] IS NULL))) AND (([DescText] = @DescText_ORG) OR ((@DescText_ORG IS NULL) AND ([DescText] IS NULL))) AND (([PathOf] = @PathOf_ORG) OR ((@PathOf_ORG IS NULL) AND ([PathOf] IS NULL))) AND (([HeaderDetail] = @HeaderDetail_ORG) OR ((@HeaderDetail_ORG IS NULL) AND ([HeaderDetail] IS NULL))) AND (([ExcludeCaseMgt] = @ExcludeCaseMgt_ORG) OR ((@ExcludeCaseMgt_ORG IS NULL) AND ([ExcludeCaseMgt] IS NULL))) AND (([SymbolName] = @SymbolName_ORG) OR ((@SymbolName_ORG IS NULL) AND ([SymbolName] IS NULL))) AND (([FName] = @FName_ORG) OR ((@FName_ORG IS NULL) AND ([FName] IS NULL))) AND (([FSize] = @FSize_ORG) OR ((@FSize_ORG IS NULL) AND ([FSize] IS NULL))) AND (([FColor] = @FColor_ORG) OR ((@FColor_ORG IS NULL) AND ([FColor] IS NULL))) AND (([FStyle] = @FStyle_ORG) OR ((@FStyle_ORG IS NULL) AND ([FStyle] IS NULL))) AND (([FCharSet] = @FCharSet_ORG) OR ((@FCharSet_ORG IS NULL) AND ([FCharSet] IS NULL))) AND (([FIndex] = @FIndex_ORG) OR ((@FIndex_ORG IS NULL) AND ([FIndex] IS NULL))) AND (([SOP] LIKE @SOP_ORG) OR ((@SOP_ORG IS NULL) AND ([SOP] IS NULL))) AND (([SQLRegionID] = @SQLRegionID_ORG) OR ((@SQLRegionID_ORG IS NULL) AND ([SQLRegionID] IS NULL))) AND (([SQLLastUpdated] = @SQLLastUpdated_ORG) OR ((@SQLLastUpdated_ORG IS NULL) AND ([SQLLastUpdated] IS NULL))) AND (([SQLIPAddress] = @SQLIPAddress_ORG) OR ((@SQLIPAddress_ORG IS NULL) AND ([SQLIPAddress] IS NULL))) AND (([SQLEmployeeID] = @SQLEmployeeID_ORG) OR ((@SQLEmployeeID_ORG IS NULL) AND ([SQLEmployeeID] IS NULL)));
Command Parameters
@SQLGUID: 'a5d320f5-f88e-42e3-be6a-5a138ad5d69a' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Current]
@Dept: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Current]
@EventNo: 'TESTABC' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Current]
@DescText: 'TESTABC123' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Current]
@PathOf: '' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Current]
@HeaderDetail: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Current]
@ExcludeCaseMgt: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Current]
@SymbolName: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Current]
@FName: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Current]
@FSize: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Current]
@FColor: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Current]
@FStyle: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Current]
@FCharSet: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Current]
@FIndex: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Current]
@SOP: '' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Current]
@SQLRegionID: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Current]
@SQLLastUpdated: '1/1/1800 12:00:00 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Current]
@SQLIPAddress: '' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Current]
@SQLEmployeeID: '' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Current]
@SQLGUID_ORGPK: 'a5d320f5-f88e-42e3-be6a-5a138ad5d69a' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@SQLGUID_ORG: 'a5d320f5-f88e-42e3-be6a-5a138ad5d69a' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: SQLGUID | SourceVersion: Original]
@Dept_ORG: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: Dept | SourceVersion: Original]
@EventNo_ORG: 'TESTABC' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: EventNo | SourceVersion: Original]
@DescText_ORG: 'TESTABC' [DbType: AnsiString | Size: 35 | Direction: Input | SourceColumn: DescText | SourceVersion: Original]
@PathOf_ORG: '' [DbType: AnsiString | Size: 8 | Direction: Input | SourceColumn: PathOf | SourceVersion: Original]
@HeaderDetail_ORG: '' [DbType: AnsiString | Size: 1 | Direction: Input | SourceColumn: HeaderDetail | SourceVersion: Original]
@ExcludeCaseMgt_ORG: '0' [DbType: Byte | Size: 1 | Direction: Input | SourceColumn: ExcludeCaseMgt | SourceVersion: Original]
@SymbolName_ORG: '' [DbType: AnsiString | Size: 143 | Direction: Input | SourceColumn: SymbolName | SourceVersion: Original]
@FName_ORG: '' [DbType: AnsiString | Size: 128 | Direction: Input | SourceColumn: FName | SourceVersion: Original]
@FSize_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FSize | SourceVersion: Original]
@FColor_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FColor | SourceVersion: Original]
@FStyle_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FStyle | SourceVersion: Original]
@FCharSet_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: FCharSet | SourceVersion: Original]
@FIndex_ORG: '' [DbType: AnsiString | Size: 20 | Direction: Input | SourceColumn: FIndex | SourceVersion: Original]
@SOP_ORG: '' [DbType: AnsiString | Size: -1 | Direction: Input | SourceColumn: SOP | SourceVersion: Original]
@SQLRegionID_ORG: '0' [DbType: Int32 | Size: 0 | Direction: Input | SourceColumn: SQLRegionID | SourceVersion: Original]
@SQLLastUpdated_ORG: '1/1/1800 12:00:00 AM' [DbType: DateTime | Size: 0 | Direction: Input | SourceColumn: SQLLastUpdated | SourceVersion: Original]
@SQLIPAddress_ORG: '' [DbType: AnsiString | Size: 15 | Direction: Input | SourceColumn: SQLIPAddress | SourceVersion: Original]
@SQLEmployeeID_ORG: '' [DbType: AnsiString | Size: 10 | Direction: Input | SourceColumn: SQLEmployeeID | SourceVersion: Original]
Command #: 3
Timestamp: 2007-01-25 09:10:33.549
General Command Settings
Command Type: Text
Object Type: System.Data.SqlClient.SqlCommand
Connection String: Data Source=DEVSVR;Initial Catalog=ETIDB_Draft1;User ID=sa;Password=eti911pc;Asynchronous Processing=True
Transaction: False
Command Settings
CommandText: SELECT [SQLGUID], [Dept], [EventNo], [DescText], [PathOf], [HeaderDetail], [ExcludeCaseMgt], [SymbolName], [FName], [FSize], [FColor], [FStyle], [FCharSet], [FIndex], [SOP], [SQLRegionID], [SQLLastUpdated], [SQLIPAddress], [SQLEmployeeID] FROM [dbo].[IncdType] WHERE ((SQLGUID = @PARAM0));
Command Parameters
@PARAM0: 'a5d320f5-f88e-42e3-be6a-5a138ad5d69a' [DbType: Guid | Size: 0 | Direction: Input | SourceColumn: | SourceVersion: Current]