dm_main.qry_local_ypml_insert.Parameters.ParamByName('UNIQUE_KEY').Value := GlobVar.qhdm;
dm_main.qry_local_ypml_insert.Parameters.ParamByName('DM').Value := DM_Main.qry_server_ypml.FieldbyName('DM').Value;
dm_main.qry_local_ypml_insert.Parameters.ParamByName('CODE_PARENT').Value := DM_Main.qry_server_ypml.FieldbyName('CODE_PARENT').value;
dm_main.qry_local_ypml_insert.Parameters.ParamByName('BH').Value := DM_Main.qry_server_ypml.FieldbyName('BH').Value;
dm_main.qry_local_ypml_insert.Parameters.ParamByName('BM').Value := DM_Main.qry_server_ypml.FieldbyName('BM').value;
dm_main.qry_local_ypml_insert.Parameters.ParamByName('MC1').Value := DM_Main.qry_server_ypml.FieldbyName('MC1').value;
dm_main.qry_local_ypml_insert.Parameters.ParamByName('MC2').Value := DM_Main.qry_server_ypml.FieldbyName('MC2').value;数据库的字段是Varchar(80),但是赋值的时候总是获得的是乱码,即便直接赋值汉字也是获得乱码,哪位帮忙看看,
跟踪错误信息如图
试验一下
注意那个N一定要有~
那就是你的delphi有问题或者你的操作系统有问题
-------------------------
另外你提供的下载没资源可下!
图片最好先在空间上传,然后在这边引用地址
该为
DM_Main.qry_server_ypml.FieldbyName('DM').asstring
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[jc_ypml]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[jc_ypml]
GOCREATE TABLE [dbo].[jc_ypml] (
[dm] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[code_parent] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[bh] [int] NULL ,
[bm] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[mc1] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[mc2] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[py] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[py2] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[sy] [tinyint] NULL ,
[zf] [tinyint] NULL ,
[sx1] [tinyint] NULL ,
[sx2] [tinyint] NULL ,
[sx3] [tinyint] NULL ,
[sx4] [tinyint] NULL ,
[sx5] [tinyint] NULL ,
[jx] [smallint] NULL ,
[gg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[dw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[jg] [money] NULL ,
[re] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[bcbl] [decimal](4, 2) NULL ,
[dj] [tinyint] NULL ,
[xj] [money] NULL ,
[int1] [int] NULL ,
[int2] [int] NULL ,
[int3] [int] NULL ,
[int4] [int] NULL ,
[int5] [int] NULL ,
[dec1] [decimal](18, 2) NULL ,
[dec2] [decimal](18, 2) NULL ,
[dec3] [decimal](18, 2) NULL ,
[dec4] [decimal](18, 2) NULL ,
[dec5] [decimal](18, 2) NULL ,
[unique_key] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
dm_main.adocommand1.Parameters.ParamByName('DM').Value := DM_Main.qry_server_ypml.FieldbyName('DM').Value;
dm_main.adocommand1.Parameters.ParamByName('CODE_PARENT').Value := DM_Main.qry_server_ypml.FieldbyName('CODE_PARENT').value;
dm_main.adocommand1.Parameters.ParamByName('BH').Value := DM_Main.qry_server_ypml.FieldbyName('BH').Value;
dm_main.adocommand1.Parameters.ParamByName('BM').Value := DM_Main.qry_server_ypml.FieldbyName('BM').value;
dm_main.adocommand1.Parameters.ParamByName('MC1').Value := DM_Main.qry_server_ypml.FieldbyName('MC1').value;
dm_main.adocommand1.Parameters.ParamByName('MC2').Value := DM_Main.qry_server_ypml.FieldbyName('MC2').value;
dm_main.adocommand1.Parameters.ParamByName('PY').Value := DM_Main.qry_server_ypml.FieldbyName('PY').value;
dm_main.adocommand1.Parameters.ParamByName('PY2').Value := DM_Main.qry_server_ypml.FieldbyName('PY2').value;
dm_main.adocommand1.Parameters.ParamByName('SY').Value := DM_Main.qry_server_ypml.FieldbyName('SY').value;
dm_main.adocommand1.Parameters.ParamByName('ZF').Value := DM_Main.qry_server_ypml.FieldbyName('ZF').value;
dm_main.adocommand1.Parameters.ParamByName('SX1').Value := DM_Main.qry_server_ypml.FieldbyName('SX1').value;
dm_main.adocommand1.Parameters.ParamByName('SX2').Value := DM_Main.qry_server_ypml.FieldbyName('SX2').value;
dm_main.adocommand1.Parameters.ParamByName('SX3').Value := DM_Main.qry_server_ypml.FieldbyName('SX3').value;
dm_main.adocommand1.Parameters.ParamByName('SX4').Value := DM_Main.qry_server_ypml.FieldbyName('SX4').value;
dm_main.adocommand1.Parameters.ParamByName('SX5').Value := DM_Main.qry_server_ypml.FieldbyName('SX5').value;
dm_main.adocommand1.Parameters.ParamByName('JX').Value := DM_Main.qry_server_ypml.FieldbyName('JX').value;
dm_main.adocommand1.Parameters.ParamByName('GG').Value := DM_Main.qry_server_ypml.FieldbyName('GG').value;
dm_main.adocommand1.Parameters.ParamByName('DW').Value := DM_Main.qry_server_ypml.FieldbyName('DW').value;
dm_main.adocommand1.Parameters.ParamByName('DJ').Value := DM_Main.qry_server_ypml.FieldbyName('DJ').value;
dm_main.adocommand1.Parameters.ParamByName('REMARK').Value := DM_Main.qry_server_ypml.FieldbyName('REMARK').value;
dm_main.adocommand1.Parameters.ParamByName('BCBL').Value := DM_Main.qry_server_ypml.FieldbyName('BCBL').value;
dm_main.adocommand1.Parameters.ParamByName('XJ').Value := DM_Main.qry_server_ypml.FieldbyName('XJ').value;
dm_main.adocommand1.Parameters.ParamByName('INT1').Value := DM_Main.qry_server_ypml.FieldbyName('INT1').value;
dm_main.adocommand1.Parameters.ParamByName('INT2').Value := DM_Main.qry_server_ypml.FieldbyName('INT2').value;
dm_main.adocommand1.Parameters.ParamByName('INT3').Value := DM_Main.qry_server_ypml.FieldbyName('INT3').value;
dm_main.adocommand1.Parameters.ParamByName('INT4').Value := DM_Main.qry_server_ypml.FieldbyName('INT4').value;
dm_main.adocommand1.Parameters.ParamByName('INT5').Value := DM_Main.qry_server_ypml.FieldbyName('INT5').value;
dm_main.adocommand1.Parameters.ParamByName('DEC1').Value := DM_Main.qry_server_ypml.FieldbyName('DEC1').value;
dm_main.adocommand1.Parameters.ParamByName('DEC2').Value := DM_Main.qry_server_ypml.FieldbyName('DEC2').value;
dm_main.adocommand1.Parameters.ParamByName('DEC3').Value := DM_Main.qry_server_ypml.FieldbyName('DEC3').value;
dm_main.adocommand1.Parameters.ParamByName('DEC4').Value := DM_Main.qry_server_ypml.FieldbyName('DEC4').value;
dm_main.adocommand1.Parameters.ParamByName('DEC5').Value := DM_Main.qry_server_ypml.FieldbyName('DEC5').value;
dm_main.adocommand1.Parameters.ParamByName('JG').Value := null;
dm_main.adocommand1.Execute;
正解,,,,,我原来用的String3ks