ado 执行语句出错
在vb6中使用ADO connection excute 执行一条insert 语句总是报错,
错误号: -2147217900 错误描述: [DB2/NT] SQL0104N 在 "2009-6-2 " 后面找到异常标记 "18"。预期标记可能包括:"INTO"。 SQLSTATE=42601
但是在DB2中单独执行却正常,不知到怎么回事。
语句如下:
Insert into PlanDataModify (PlantID,unitID,dt,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22,T23,T24,T25,T26,T27,T28,T29,T30,T31,T32,T33,T34,T35,T36,T37,T38,T39,T40,T41,T42,T43,T44,T45,T46,T47,T48,T49,T50,T51,T52,T53,T54,T55,T56,T57,T58,T59,T60,T61,T62,T63,T64,T65,T66,T67,T68,T69,T70,T71,T72,T73,T74,T75,T76,T77,T78,T79,T80,T81,T82,T83,T84,T85,T86,T87,T88,T89,T90,T91,T92,T93,T94,T95,T96,T97,T98,T99,T100,T101,T102,T103,T104,T105,T106,T107,T108,T109,T110,T111,T112,T113,T114,T115,T116,T117,T118,T119,T120,T121,T122,T123,T124,T125,T126,T127,T128,T129,T130,T131,T132,T133,T134,T135,T136,T137,T138,T139,T140,T141,T142,T143,T144,T145,T146,T147,T148,T149,T150,T151,T152,T153,T154,T155,T156,T157,T158,T159,T160,T161,T162,T163,T164,T165,T166,T167,T168,T169,T170,T171,T172,T173,T174,T175,T176,T177,T178,T179,T180,T181,T182,T183,T184,T185,T186,T187,T188,T189,T190,T191,T192,T193,T194,T195,T196,T197,T198,T199,T200,T201,T202,T203,T204,T205,T206,T207,T208,T209,T210,T211,T212,T213,T214,T215,T216,T217,T218,T219,T220,T221,T222,T223,T224,T225,T226,T227,T228,T229,T230,T231,T232,T233,T234,T235,T236,T237,T238,T239,T240,T241,T242,T243,T244,T245,T246,T247,T248,T249,T250,T251,T252,T253,T254,T255,T256,T257,T258,T259,T260,T261,T262,T263,T264,T265,T266,T267,T268,T269,T270,T271,T272,T273,T274,T275,T276,T277,T278,T279,T280,T281,T282,T283,T284,T285,T286,T287,T288) values ('YZPP', 1, '2009-06-02 00:00:00',481,466.82,470.82,474.82,479.33,483.84,488.36,489.68,491.02,492.34,492.28,492.24,492.18,493.12,494.06,495,494.46,493.92,493.36,493.52,493.68,493.84,492.3,490.78,489.26,489.9,490.56,491.2,489.62,488.04,486.46,485.58,484.68,483.8,483.98,484.16,484.34,482.96,481.58,480.2,480.38,480.58,480.78,480.48,480.18,479.88,480.02,480.14,480.28,480.48,480.68,480.9,482.16,483.43,484.7,486.3,487.9,489.5,492.32,495.16,498,500.52,503.04,505.56,509.04,512.52,516,518.66,521.34,524,525.34,526.66,528,526.66,525.34,524,520,516,512,508,504,500,499.86,499.72,499.6,500.4,501.2,502,502.3,502.58,502.88,503.1,503.3,503.52,491.68,479.84,468,460.66,453.34,446,446.38,446.78,447.16,447.44,447.72,448,447.34,446.66,446,449.1,452.2,455.31,458.26,461.22,464.18,467.96,471.72,475.48,478.32,481.16,484,487.56,491.12,494.68,496.28,497.88,499.48,498.98,498.5,498,489.34,480.66,472,472,472,472,466.66,461.34,456,450,444,438,437.34,436.66,436,440.34,444.66,449,450.88,452.76,454.64,456.1,457.58,459.04,460.48,461.92,463.36,464.91,466.48,468.04,470.81,473.58,476.34,477.97,479.59,481.22,481.76,482.29,482.83,483.03,483.23,483.43,484.56,485.68,486.82,487.05,487.28,487.52,487.44,487.38,487.3,486.54,485.78,485.01,485.94,486.86,487.8,487.98,488.16,488.36,488.14,487.94,487.72,488.14,488.54,488.94,488.2,487.46,486.72,486.04,485.38,484.7,478.92,473.12,467.34,464.7,462.04,459.4,455.24,451.06,446.9,441.92,436.96,432,429.34,426.66,424,424,424,424,424,424,424,426,428,430,432.66,435.34,438,441.34,444.66,448,451.34,454.66,458,458.66,459.34,460,459.34,458.66,458,461.34,464.66,468,470,472,474,476.66,479.34,482,486.44,490.9,495.34,500.56,505.78,511,511.1,511.2,511.3,507.54,503.76,500,497.04,494.08,491.12,488.08,485.04,482,480,478,476,473.82,471.64,469.46,470.3,471.16,472,470.66,469.34,468,466.32,464.66,462.98,460.96,458.94,456.92,459.94,462.98)