TClientDataSet 保存为xml问题 ( 积分: 200 )

A

aylm

Unregistered / Unconfirmed
GUEST, unregistred user!
我在使用oracle&nbsp;中遇到一个郁闷的问题.<br>TClientDataSet.xmlData的使用过程中,发现对于有的版本的oracle数据库在处理number类型字段数据时xmlData中的数据类型被保存为Fixed类型,但是数据并没有取到.但是对于其它版本的oracle数据库就没有问题.数据类型为r8<br>Oracle9i&nbsp;Enterprise&nbsp;Edition&nbsp;Release&nbsp;9.2.0.1.0&nbsp;-&nbsp;64bit<br>&lt;?xml&nbsp;version=&quot;1.0&quot;&nbsp;standalone=&quot;yes&quot;?&gt;&nbsp;&nbsp;&lt;DATAPACKET&nbsp;Version=&quot;2.0&quot;&gt;&lt;METADATA&gt;&lt;FIELDS&gt;&lt;FIELD&nbsp;attrname=&quot;USERID&quot;&nbsp;fieldtype=&quot;fixed&quot;&nbsp;DECIMALS=&quot;4&quot;&nbsp;WIDTH=&quot;255&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;USERNO&quot;&nbsp;fieldtype=&quot;string.uni&quot;&nbsp;WIDTH=&quot;20&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;USERNAME&quot;&nbsp;fieldtype=&quot;string.uni&quot;&nbsp;WIDTH=&quot;60&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;LIMITID&quot;&nbsp;fieldtype=&quot;fixed&quot;&nbsp;DECIMALS=&quot;4&quot;&nbsp;WIDTH=&quot;255&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;USERPASSWORD&quot;&nbsp;fieldtype=&quot;string.uni&quot;&nbsp;WIDTH=&quot;60&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;COMPANYID&quot;&nbsp;fieldtype=&quot;fixed&quot;&nbsp;DECIMALS=&quot;4&quot;&nbsp;WIDTH=&quot;255&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;PHONENUMBER&quot;&nbsp;fieldtype=&quot;string.uni&quot;&nbsp;WIDTH=&quot;26&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;ROLEID&quot;&nbsp;fieldtype=&quot;string.uni&quot;&nbsp;WIDTH=&quot;2048&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;ALTERID&quot;&nbsp;fieldtype=&quot;fixed&quot;&nbsp;DECIMALS=&quot;4&quot;&nbsp;WIDTH=&quot;255&quot;/&gt;&lt;/FIELDS&gt;&lt;PARAMS/&gt;&lt;/METADATA&gt;&lt;ROWDATA&gt;&lt;ROW&nbsp;USERID=&quot;&quot;&nbsp;USERNO=&quot;fmer&quot;&nbsp;USERNAME=&quot;&amp;#26446;&amp;#26126;&quot;&nbsp;LIMITID=&quot;&quot;&nbsp;USERPASSWORD=&quot;8997A880D065&quot;&nbsp;COMPANYID=&quot;&quot;&nbsp;PHONENUMBER=&quot;1234567&quot;&nbsp;ROLEID=&quot;100&quot;&nbsp;ALTERID=&quot;&quot;/&gt;&lt;/ROWDATA&gt;&lt;/DATAPACKET&gt;<br><br>Oracle9i&nbsp;Enterprise&nbsp;Edition&nbsp;Release&nbsp;9.2.0.8.0&nbsp;-&nbsp;64bit&nbsp;<br>&lt;?xml&nbsp;version=&quot;1.0&quot;&nbsp;standalone=&quot;yes&quot;?&gt;&nbsp;&nbsp;&lt;DATAPACKET&nbsp;Version=&quot;2.0&quot;&gt;&lt;METADATA&gt;&lt;FIELDS&gt;&lt;FIELD&nbsp;attrname=&quot;USERID&quot;&nbsp;fieldtype=&quot;r8&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;USERNO&quot;&nbsp;fieldtype=&quot;string.uni&quot;&nbsp;WIDTH=&quot;20&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;USERNAME&quot;&nbsp;fieldtype=&quot;string.uni&quot;&nbsp;WIDTH=&quot;60&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;LIMITID&quot;&nbsp;fieldtype=&quot;r8&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;USERPASSWORD&quot;&nbsp;fieldtype=&quot;string.uni&quot;&nbsp;WIDTH=&quot;60&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;COMPANYID&quot;&nbsp;fieldtype=&quot;r8&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;PHONENUMBER&quot;&nbsp;fieldtype=&quot;string.uni&quot;&nbsp;WIDTH=&quot;26&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;ROLEID&quot;&nbsp;fieldtype=&quot;string.uni&quot;&nbsp;WIDTH=&quot;2048&quot;/&gt;&lt;FIELD&nbsp;attrname=&quot;ALTERID&quot;&nbsp;fieldtype=&quot;r8&quot;/&gt;&lt;/FIELDS&gt;&lt;PARAMS/&gt;&lt;/METADATA&gt;&lt;ROWDATA&gt;&lt;ROW&nbsp;USERID=&quot;21&quot;&nbsp;USERNO=&quot;fmer&quot;&nbsp;USERNAME=&quot;&amp;#26446;&amp;#26126;&quot;&nbsp;LIMITID=&quot;99&quot;&nbsp;USERPASSWORD=&quot;8997A880D065&quot;&nbsp;COMPANYID=&quot;3&quot;&nbsp;PHONENUMBER=&quot;1234567&quot;&nbsp;ROLEID=&quot;100&quot;&nbsp;ALTERID=&quot;31&quot;/&gt;&lt;/ROWDATA&gt;&lt;/DATAPACKET&gt;<br>?
 
难道没有人遇到过类似的问题?
 
有没有高手???
 
数据库<br>Oracle9i&nbsp;Enterprise&nbsp;Edition&nbsp;Release&nbsp;9.2.0.1.0<br>就是r8<br>没有问题啊!
 
我是用的是TClientDataSet.xmlData,是fixed呀?郁闷死了.
 
顶部