OdbcConnection myConn = new OdbcConnection(@"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=C:\\FEPOS\\data"); //在D盘下 路径 dbf文件名2005
myConn.Open();
string ping = "DGS001BJ070001";
//string sql = " delete from tr_transfer where tr_code = '" + ping + "'";
string sql = " delete from tr_transfer where tr_code ='DGS001BJ070001' ";
OdbcCommand cmd = new OdbcCommand(sql,myConn);
cmd.ExecuteNonQuery();
myConn.Close();条件删除dBF
提示错误 请帮忙解决!
ERROR [23000] [Microsoft][ODBC Visual FoxPro Driver]Trigger failed.
myConn.Open();
string ping = "DGS001BJ070001";
//string sql = " delete from tr_transfer where tr_code = '" + ping + "'";
string sql = " delete from tr_transfer where tr_code ='DGS001BJ070001' ";
OdbcCommand cmd = new OdbcCommand(sql,myConn);
cmd.ExecuteNonQuery();
myConn.Close();条件删除dBF
提示错误 请帮忙解决!
ERROR [23000] [Microsoft][ODBC Visual FoxPro Driver]Trigger failed.
解决方案 »
- 线程 关闭窗口 问题
- 关于Excel表的问题~~
- C#保存,新增,删除,修改数据,怎么提交数据库.在线等.解决马上结贴
- 高手请进
- 项目外包
- 急啊,不能引用报表文件,myReport rpt = new myReport()出错
- 简单问:)欢迎拿分。winform 的TrewView 如何才能只让子结点响应 click事件
- 怎么取得不要秒的日期
- 急!如何确定一个字符串中中文汉字的个数????谢谢!
- 同学们、前辈们好。我有一个问题求助是关于C#导入C++生成的DLL的
- VS.net开发的C/S系统,访问oracle,客户端必须装oracle client吗?
- 线程操作窗体控件问题,吊死一棵树!!!!!!!!!!!
OdbcConnection oCn = new OdbcConnection("DSN=vf");
vf是数据源的名称