>>>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>