Duplicate Recordset Issue in XML file

[atnpowell]

Hi
I'm writing a nested recordset to an xml file in a vb app, but am having a major problem. Two of my records are identical apart from one of the primary key values is lower case and the other is upper.
The XML file seems to assume they are the same and writes this..

rs:duplicate='true'

But they are two different records in my SQL database .!!

How can I write these two records to file successfully, as currently it throws up a duplicate record error when I try to read the recordset back into the database.

 

[jel]

It's not the xml-file that does the thinking...
I guess you let SQL-server 2000 generate xml? In that case: are you sure that the records realy are different to SQL-server? Can you add unique index on your primary key-field?