星星们,该你们出来闪烁了
用一个adoquery一次执行,出错[不正常地定义参数对象.提供了不一致或不完整的信息] 。
delphi7+ado2.7+sql2000.关键是用sql查询分析器一次执行不会出错,具体分析,:和`这个符号的问题,大家可以测试测试。
insert into [37020000_2005_B_B201_3] (sys_SbTime,Sys_SBQ,sys_Zhcode,sys_QyName,sys_id1,SYS_Code,SYS_Name,SYS_Unit,V001,V002,V003,V004,Sys_Del) values ('2005-01-20 10:04:16','200501','37020026','111','000000001','2222',':','`',null,null,null,null,'1')
insert into [37020000_2005_B_B201_3] (sys_SbTime,Sys_SBQ,sys_Zhcode,sys_QyName,sys_id1,SYS_Code,SYS_Name,SYS_Unit,V001,V002,V003,V004,Sys_Del) values ('2005-01-19 20:21:54','200501','37020022','3厂','000000003',null,null,null,null,null,null,null,'1')
表定义
CREATE TABLE [dbo].[37020000_2005_B_B201_3] (
[SyS_ID1] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[Sys_QYName] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[Sys_ZhCode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Sys_SBQ] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Sys_Del] [int] NULL ,
[SYS_Name] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[SYS_Unit] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SYS_Code] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[V001] [decimal](17, 2) NULL ,
[V002] [decimal](17, 2) NULL ,
[V003] [decimal](17, 2) NULL ,
[V004] [decimal](17, 2) NULL ,
[Sys_sh] [int] NULL ,
[Sys_ys] [int] NULL ,
[Sys_yszh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Sys_ysinfo] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Sys_SbTime] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Sys_DataID] [numeric](38, 0) IDENTITY (1, 1) NOT NULL ,
[Sys_Kz1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Sys_Kz2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO