Does any one know the max fieldcount in a single post operation that Oracle support

odacuil · Post by **odacuil** » Wed 11 Oct 2006 09:07

Does any one know the max fieldcount in a single post operation that Oracle support?

I encounter a problem that I am not sure if it is due to ODAC.
When a table has more than 500 fields, only the first several hundrends of fields can be posted if I excute dataset.post.

The program is very simple.
A oratable connects to a table with about 300 fields.
A datasource connects to the oratable.
A crdbgrid connects to the datasource.
Only the first 100 fields can be modified. Althought I can edit the data in last 100 fields, the data remain unmodified when I refresh.

Challenger · Post by **Challenger** » Wed 11 Oct 2006 12:24

We couldn't reproduce this error. Please try to enable Debug mode and check that edited fields are used in update SQL statement.

odacuil · Post by **odacuil** » Tue 17 Oct 2006 13:46

challenger wrote:We couldn't reproduce this error. Please try to enable Debug mode and check that edited fields are used in update SQL statement.

How to enable Debug mode and check that edited fields are used in update sql statement? Thanks

Challenger · Post by **Challenger** » Tue 17 Oct 2006 14:11

You should set Debug property of TOraTable to True and explicitly include to your project unit OdacVcl.

odacuil · Post by **odacuil** » Tue 17 Oct 2006 15:46

where can I test or execute the displayed code

INSERT INTO xmxx
(XMBH, JSXZ, JSGM1, JSGM2, KYSC, KYPF, ZHAOBIAO, CSSC, ZSBZB, ZSJGSPF, SBKGJH, GCKG, TJSG, SBAZ, XTTS, TCSD, XMZRDW, JSGM5, DYDJ, LXSJ, JHDW, XMZGDW, SX1, SX2, SX3, AQWM, DAYJ, JGJS)
VALUES
(:1, :4, :5, :6, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :25, :39, :40, :45, :46, :47, :48, :49, :56, :59, :61)

:1(VARCHAR[12],IN)='120070220005'
:4(VARCHAR[4],IN)='cvb'
:5(FLOAT,IN)=1
:6(FLOAT,IN)=20
:8(DATE,IN)='2006-10-17'
:9(DATE,IN)='2006-10-17'
:10(DATE,IN)='2006-10-17'
:11(DATE,IN)='2006-10-17'
:12(DATE,IN)='2006-10-17'
:13(DATE,IN)='2006-10-17'
:14(DATE,IN)='2006-10-17'
:15(DATE,IN)='2006-10-17'
:16(DATE,IN)='2006-10-17'
:17(DATE,IN)='2006-10-17'
:18(DATE,IN)='2006-10-17'
:19(DATE,IN)='2006-10-17'
:20(VARCHAR[1],IN)='1'
:25(FLOAT,IN)=18
:39(VARCHAR[7],IN)='220'
:40(DATE,IN)='2007-10-17'
:45(VARCHAR[1],IN)='1'
:46(VARCHAR[6],IN)=''
:47(VARCHAR[2],IN)=''
:48(VARCHAR[2],IN)='-1'
:49(VARCHAR[4],IN)='2007'
:56(DATE,IN)='2006-10-17'
:59(DATE,IN)='2006-10-17'
:61(DATE,IN)='2006-10-17'

Challenger · Post by **Challenger** » Fri 20 Oct 2006 06:46

You can fill SQL property of TOraSQL, TOraQuery or TSmartQuery with this INSERT SQL statement. Fill Params with the values that are mentioned below. And call Execute method.
But in the previous post I asked you to change(or fill) all fields of your table and check that all these fields are included into INSERT SQL statement displayed in the Debug window.