4.4 Set Field

  • Article

This example sets a String field named "TestString" to a value of "abc" on a record with identifier -4.8036800520483017E-096 in the repository.

 <urn:groove.net:Cmd CMD="6" DBName="TestDatabase1" EngineURL="ToolContainer/yrp57967myg94/RDBManager" Name="TestString" PurNot="" TableDefID="-1" Type="1" Value="abc" _Modified="1202396046342" _RecordID="-4.8036800520483017E-096"/>

This example sets a Boolean field named "TestBool" to a value of True on a record with identifier -2.8414202314964928E-094.

 <urn:groove.net:Cmd CMD="6" DBName="TestDatabase1" EngineURL="ToolContainer/yrp57967myg94/RDBManager" Name="TestBool" PurNot="" TableDefID="-1" Type="2" _Modified="1203108416062" _RecordID="-2.8414202314964928E-094"/>

This example sets a Four Byte Signed Integer field named "TestI4" to a value of 12345 on a record with identifier -2.8414202314964928E-094.

 <urn:groove.net:Cmd CMD="6" DBName="TestDatabase1" EngineURL="ToolContainer/yrp57967myg94/RDBManager" Name="TestI4" PurNot="" TableDefID="-1" Type="5" Value="12345" _Modified="1203108416062" _RecordID="-2.8414202314964928E-094"/>

This example sets a Double field named "TestR8" to a value of 1.2344999999999999 on a record with identifier -2.8414202314964928E-094.

 <urn:groove.net:Cmd CMD="6" DBName="TestDatabase1" EngineURL="ToolContainer/yrp57967myg94/RDBManager" Name="TestR8" PurNot="" TableDefID="-1" Type="7" Value="1.2344999999999999" _Modified="1203108416077" _RecordID="-2.8414202314964928E-094"/>

This example sets a Date/Time field named "TestDateTime" to a value of Tuesday, March 04, 2008 1:14:49 PM GMT, with the value encoded in the message as 1204636489000 on a record with identifier -8.6465898231952427E+124.

 <urn:groove.net:Cmd CMD="6" DBName="TestDatabase1" EngineURL="ToolContainer/yrp57967myg94/RDBManager" Name="TestDateTime" PurNot="" TableDefID="-1" Type="9" Value="1204636489000" _Modified="1203108416077" _RecordID="-2.8414202314964928E-094"/>

This example sets a Binary field named "TestBinary" to a value of a 1024 byte binary stream in a record with identifier -1.4948713963691306E-005. The contents of the stream are the byte position within the stream plus the byte value of the character "A", that is the first byte in the stream is ‘A’ + 0, the second is ‘A’ + 1, and so on.

 <urn:groove.net:Cmd CMD="6" DBName="TestDatabase1" EngineURL="ToolContainer/yrp57967myg94/RDBManager" Name="TestBinary" PurNot="" TableDefID="-1" Type="8" Value="QUJDREVGR0hJSktMTU5PUFFSU1RVVldYWVpbXF1eX2BhYmNkZWZnaGlqa2xtbm9wcXJzdHV2d3h5ent8fX5/gIGCg4SFhoeIiYqLjI2Oj5CRkpOUlZaXmJmam5ydnp+goaKjpKWmp6ipqqusra6vsLGys7S1tre4ubq7vL2+v8DBwsPExcbHyMnKy8zNzs/Q0dLT1NXW19jZ2tvc3d7f4OHi4+Tl5ufo6err7O3u7/Dx8vP09fb3+Pn6+/z9/v8AAQIDBAUGBwgJCgsMDQ4PEBESExQVFhcYGRobHB0eHyAhIiMkJSYnKCkqKywtLi8wMTIzNDU2Nzg5Ojs8PT4/QEFCQ0RFRkdISUpLTE1OT1BRUlNUVVZXWFlaW1xdXl9gYWJjZGVmZ2hpamtsbW5vcHFyc3R1dnd4eXp7fH1+r+QkZKTlJWWl5iZmpucnZ6foKGio6SlpqeoqaqrrK2ur7CxsrO0tba3uLm6u7y9vr/AwcLDxMXGx8jJysvMzc7P0NHS09TV1tfY2drb3N3e3+Dh4uPk5ebn6Onq6+zt7u/w8fLz9PX29/j5+vv8/f7/AAECAwQFBgcICQoLDA0ODxAREhMUFRYXGBkaGxwdHh8gISIjJCUmJygpKissLS4vMDEyMzQ1Njc4OTo7PD0+P0BBQkNERUZHSElKS0xNTk9QUVJTVFVWV1hZWltcXV5fYGFiY2RlZmdoaWprbG1ub3BxcnN0dXZ3eHl6e3x9fn+AgYKDhIWGh4iJiouMjY6PkJGSk5SVlpeYmZqbnJ2en6ChoqOkpaanqKmqq6ytrq+wsbKztLW2t7i5uru8vb6/wMHCw8TFxsfIycrLzM3Oz9DR0tPU1dbX2Nna29zd3t/g4eLj5OXm5+jp6uvs7e7v8PHy8/T19vf4+fr7/P3+/wABAgMEBQYHCAkKCwwNDg8QERITFBUWFxgZGhscHR4fICEiIyQlJicoKSorLC0uLzAxMjM0NTY3ODk6Ozw9Pj9AQUJDREVGR0hJSktMTU5PUFFSU1RVVldYWVpbXF1eX2BhYmNkZWZnaGlqa2xtbm9wcXJzdHV2d3h5ent8fX5/gIGCg4SFhoeIiYqLjI2Oj5CRkpOUlZaXmJmam5ydnp+goaKjpKWmp6ipqqusra6vsLGys7S1tre4ubq7vL2+v8DBwsPExcbHyMnKy8zNzs/Q0dLT1NXW19jZ2tvc3d7f4OHi4+Tl5ufo6err7O3u7/Dx8vP09fb3+Pn6+/z9/v8AAQIDBAUGBwgJCgsMDQ4PEBESExQVFhcYGRobHB0eHyAhIiMkJSYnKCkqKywtLi8wMTIzNDU2Nzg5Ojs8PT4/QA==" _Modified="1203339680345" _RecordID="-1.4948713963691306E-005"/>