oracle10g时,假如某字段为number(4),某记录值为10010,用adoquery的savetofile后的xml文件里值变为10了,前面的100自动舍弃了,有遇到此问题的吗?谢谢
解决方案 »
- 数据相应字段生成head头,超难。。高手来回答
- 求SQL语句.......................................................(标题要长)
- 如何取出存在oracle数据库中blob类型中的word文档呢?请高手指点
- 如何入门ORACLE数据库开发
- Oracle 10g XE 自动创建数据库的问题
- oracle数据存储返回字符串为空?
- 服务器上一直用得好好的,今天突然客户机连不上去了。说找不到对象主机后对象不存在。
- 高分相送,用asp连接oracle9i的问题,在线等待!
- 请问oracle中有没有可动态执行sql语句的函数?
- 紧急求助(高手请进!有高分!!!)奇怪的oracle安装问题(哑巴oracle)!
- oracle forms里怎么做 file dialog?
- 请教,存储过程中处理long raw字段类型的数据,非常感谢!
貌似字段根本不够长嘛
SQL> create table t(idx int,value number(4));Table created.SQL> insert into t values(1,10010);
insert into t values(1,10010)
*
ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column
SQL> insert into t values(1,1010);1 row created.SQL> commit;Commit complete.SQL>
adoQuery1.SaveToFile('c:\1.xml');
看结果正确,我的版本11G,Delphi 6<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly' rs:updatable='true'>
<s:AttributeType name='IDX' rs:number='1' rs:nullable='true' rs:writeunknown='true' rs:basetable='T' rs:basecolumn='IDX'>
<s:datatype dt:type='number' rs:dbtype='numeric' dt:maxLength='19' rs:scale='0' rs:precision='38' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='VALUE' rs:number='2' rs:nullable='true' rs:writeunknown='true' rs:basetable='T' rs:basecolumn='VALUE'>
<s:datatype dt:type='number' rs:dbtype='numeric' dt:maxLength='19' rs:scale='0' rs:precision='4' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='ROWID' rs:number='3' rs:rowid='true' rs:basetable='T' rs:basecolumn='ROWID' rs:keycolumn='true'
rs:hidden='true' rs:autoincrement='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='18' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row IDX='1' VALUE='1010' ROWID='AAARg9AAEAAAAIHAAA'/>
</rs:data>
</xml>
select * from tabname where colname=10010
如果没有这条数据,说明不是delphi的导入错误,而是本身就没有这个数