如何利用QueryDataSet操作Blob字段？困扰已久，解决后一定高分相赠。

[cswei1021]

我用的是Oracle 9i，JB2005。
问题是这样的：QueryDataSet中只要包含了Blob字段，则QueryDataSet根本无法打开。qds.open()时，报如下错误：
See com.borland.dx.dataset.DataSetException error code: BASE+62
com.borland.dx.dataset.DataSetException: Execution of query failed.
...............
Chained exception:
java.lang.NumberFormatException: For input string: "4294967295"
...............
在下怀疑与QDS的相关设置有关，但网上资料很少，一直无法解决，望高手指定在下，一定不胜感激！！！！！
QQ：3766369
PoPo:cswei1021
Email:[e-mail]
请高手不要手下留情啊！！！

[cswei1021]

补充一下：是否应该用Data Express的其他控件来操作Blob字段，而不一定是QueryDataSet？

[cswei1021]

我在Borland的社区中找到了如下的类似问题解答，但问题说的是如何保存Blob字段，可我连包含Blob字段的QDS都无法打开，如何进一步操作呢？唉。。。高手帮帮忙吧。。。。
－－－－－－－－－－－－－－－－－－－
Question:
I'm having problems with BLOB fields. I can't save them nor
can I change them. Any hints?

Answer:
Turns out there are several different behaviours/requirements
from various SQL servers for searched updates on blob fields
like VARCHAR. BDE sql links will not include such fields in
the where clause of a searched update. We will probably make
this same change in the future.

There are three possible solutions for now (number 1 or 2 are
more desirable):

1) Set the QueryResolver.UpdateMode property to
UpdateMode.KEY_COLUMNS. QueryResolver component must be
added to QueryDataSet's container and set on the QueryDataSet's
Resolver property.

2) Before calling Database.saveChanges(), set the
Column.Searchable property to false. This must always be done
after the QueryDataSet's query is run (from QueryDataSet.open()
or QueryDataSet.executeQuery()) method because the
Column.searchable property will be overridden by metadata
inspection when the query is run.

3) Set QueryDataSet.MetaDataUpdate to NONE. This forces you to
set all the appropriate metadata info on the column
component including Column.RowId, and Column.Searchable
properties.
－－－－－－－－－－－－－－－－－－－－－－－－－