合并dbf表出现Command contains unrecognized phrase/keyword.的错误
最近项目要求导出dbf表,总共有45张dbf表,其中一张是空表,我需要将其他44张表中的数据全部追加到这张空表当中,下面是代码
DbfWriter writer = new DbfWriter(filePath, CJXDM_TableCreateCommand);//CJXDM_TableCreateCommand是创建表的命令
try
{
writer.Open();
writer.AppendData(sb.ToString());//sb.ToString()是追加数据的命令(如下所示)
//AppendData()中有执行sql语句的方法
}
//下面是sql语句(sb.ToString())
USE td_cjxdm.dbf
APPEND FROM lq_cjk_cwdj.dbf
APPEND FROM lq_cjk_dfzxhg.dbf
APPEND FROM lq_cjk_dkhyw.dbf
APPEND FROM lq_cjk_dkjn.dbf
APPEND FROM lq_cjk_dkmzyw.dbf
APPEND FROM lq_cjk_dksx.dbf
APPEND FROM lq_cjk_dktzf.dbf
APPEND FROM lq_cjk_dkwy.dbf
APPEND FROM lq_cjk_dkyw.dbf
APPEND FROM lq_cjk_dkzgf.dbf
APPEND FROM lq_cjk_dkzh.dbf
APPEND FROM lq_cjk_dkzrzf.dbf
APPEND FROM lq_cjk_fsspxzf.dbf
APPEND FROM lq_cjk_fsstyzf.dbf
APPEND FROM lq_cjk_fsszf.dbf
APPEND FROM lq_cjk_gajhg.dbf
APPEND FROM lq_cjk_gjzxhg.dbf
APPEND FROM lq_cjk_jjhg.dbf
APPEND FROM lq_cjk_jqrdssmz.dbf
APPEND FROM lq_cjk_mj.dbf
APPEND FROM lq_cjk_msjsf.dbf
APPEND FROM lq_cjk_mslxkhg.dbf
APPEND FROM lq_cjk_my.dbf
APPEND FROM lq_cjk_mzyw.dbf
APPEND FROM lq_cjk_sfjhg.dbf
APPEND FROM lq_cjk_sspxzf.dbf
APPEND FROM lq_cjk_sstyzf.dbf
APPEND FROM lq_cjk_sszf.dbf
APPEND FROM lq_cjk_sx.dbf
APPEND FROM lq_cjk_tl.dbf
APPEND FROM lq_cjk_tshcj.dbf
APPEND FROM lq_cjk_tsyszyxkhg.dbf
APPEND FROM lq_cjk_tyjsf.dbf
APPEND FROM lq_cjk_tyyszhg.dbf
APPEND FROM lq_cjk_tzf.dbf
APPEND FROM lq_cjk_wdlxkhg.dbf
APPEND FROM lq_cjk_whkzf.dbf
APPEND FROM lq_cjk_wy.dbf
APPEND FROM lq_cjk_wykscj.dbf
APPEND FROM lq_cjk_xjyysxkhg.dbf
APPEND FROM lq_cjk_yw.dbf
APPEND FROM lq_cjk_yylxkhg.dbf
APPEND FROM lq_cjk_zh.dbf
APPEND FROM lq_cjk_zkysxkhg.dbf
但始终报错:Command contains unrecognized phrase/keyword.
哪位神能帮我解解惑!