Results 1 to 6 of 6

Thread: Bug with DataSet.ReadXMLSchema

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    518

    Bug with DataSet.ReadXMLSchema

    Apparently when using the DataSet.ReadXMLSchema, if you want a string field to have a DefaultValue of "" this is not interpreted correctly when the table is built. The DefaultValue for the field ends up being DBNull.

    Here's a sample segment (which was written originally by DataSet.WriteXMLSchema):
    Code:
    <xs:element name="Bonus" msdata:CaseSensitive="True">
    	<xs:complexType>
    		<xs:sequence>
    			<xs:element name="Name" type="xs:string" />
    			<xs:element name="Value" type="xs:string" default="" minOccurs="0" />
    		</xs:sequence>
    	</xs:complexType>
    </xs:element>
    Irritating as I will have to go change a bunch of code to cope with this! Heads up!

  2. #2
    Frenzied Member
    Join Date
    Oct 2002
    Location
    Gammapolis
    Posts
    1,474
    Well it's a known issue that is fixed in Framework 1.1.
    'Heading for the automatic overload'
    Marillion, Brave, The Great Escape, 1994

    'How will WE stand the FIRE TOMORROW?'
    Eloy, Silent Cries and Mighty Echoes, The Vision - Burning, 1979

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    518
    Huh? I am service packed and still have this problem.

  4. #4

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    518
    By the way where are you getting the information that this is an acknowledged bug, much less that it is fixed?

  5. #5
    Frenzied Member
    Join Date
    Oct 2002
    Location
    Gammapolis
    Posts
    1,474
    'Heading for the automatic overload'
    Marillion, Brave, The Great Escape, 1994

    'How will WE stand the FIRE TOMORROW?'
    Eloy, Silent Cries and Mighty Echoes, The Vision - Burning, 1979

  6. #6

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    518
    Thanks for the info. Sure enough I seem to have version 1.0 installed. I had thought that the service pack took you to 1.1, guess it does not. grumble!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width