Mike Sue-Ping
Cambridge, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>>>Is there anyway around this without changing the XSD?
>>>
>>
>>Hi Mike,
>>
>>Manually change DataType property of the corresponding XMLField object after LoadXML.
>>
>>Thanks,
>>Aleksey.
>
>Hi Aleksey,
>
>I know its been a while since I raised this question. Thanks for the reply.
>
>I was wondering if you could provide more details about your suggestion. Are you saying that I could loop thru all of the XMLField objects and set some property named "DataType"? If so, to what? Some "large enough" size?
>
>Regards,
>
>Mike
Hi Mike,
Yes, if you think the data will fit into a Char or Varchar field, you can loop through XMLTable.Fields collection and change XMLField.DataType property from 'M' to 'C' or 'V' and XMLField.MaxLength to some "large enough" size.
Thanks,
Aleksey.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement