>>>>Hi everybody,
>>>>
>>>>We receive an XML from the .NET webservice. The GUID field is described as
>>>>
>>>>

>>>><xs:element name="OrderPk" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string"/>

>>>>
>>>>When we convert the XML into the cursor using XMLAdapter.LoadXML method the GUID fields come as Memo. Is there a way to create them as character strings instead?
>>>>
>>>>Thanks in advance.
>>>
>>>No ideas, anyone?
>>
>>A small sample xml would be helpful for people willing to be helpful
>
>See here (I shortened it a bit)
>
>

><RetrieveFinalizedOrdersResult xmlns="http://tempuri.org/">
><xs:schema id="NewDataSet" xmlns="" 
>xmlns:xs="http://www.w3.org/2001/XMLSchema" 
>xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
><xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="Orders" msdata:UseCurrentLocale="true">
><xs:complexType><xs:choice minOccurs="0" maxOccurs="unbounded"><xs:element name="Orders" msprop:SelectCommand="System.Data.SqlClient.SqlCommand"><xs:complexType><xs:sequence><xs:element name="OrderPk" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string"/><xs:element name="CustomerFK" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" minOccurs="0"/>
><xs:element name="OrderDate" type="xs:dateTime" minOccurs="0"/>
><xs:element name="OrderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int"/>
><xs:element name="LastEditDate" type="xs:dateTime" minOccurs="0"/><xs:element name="CreationDate" type="xs:dateTime" minOccurs="0"/>
><xs:element name="Finalized" type="xs:dateTime" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:choice></xs:complexType><xs:unique name="Constraint1" msdata:PrimaryKey="true">
><xs:selector xpath=".//Orders"/><xs:field xpath="OrderPk"/></xs:unique></xs:element></xs:schema><diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" 
>xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
><NewDataSet xmlns=""><Orders diffgr:id="Orders1" msdata:rowOrder="0">
><OrderPk>29233027-e8cd-4efe-b1ae-20a10d97cc30</OrderPk>
><OrderDate>2009-05-14T14:16:25.377-05:00</OrderDate><OrderID>6</OrderID><LastEditDate>2009-05-19T18:45:43.793-05:00</LastEditDate><CreationDate>2009-05-14T19:09:10.107-05:00</CreationDate><Finalized>2009-05-20T18:15:43.14-05:00</Finalized></Orders></diffgr:diffgram></RetrieveFinalizedOrdersResult>

Can you at least give something that loads, ie correctly formatted xml (see image)