UPDATE SQL 语法错误??? strSQL.Format("update GDKTable set GBHM ='11' where GBHM ='22'");我用的ACCESS 数据库报错"FROM 字句语法错误"在线等待 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 #import "c:\Program Files\Common Files\System\ADO\msado20.tlb" no_namespace rename("EOF", "EndOfFile")#include <windows.h>#include <comdef.h>void main(){ ::CoInitialize(NULL); _ConnectionPtr pConnectionPtr; _CommandPtr pCommandPtr; try { pConnectionPtr.CreateInstance (__uuidof(Connection)); pCommandPtr.CreateInstance (__uuidof(Command)); _bstr_t strConnect = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\杂项\\db1.mdb;" "User Id=管理员;Password=123;Exclusive=1;"; pConnectionPtr ->Open (strConnect,"","",NULL); pCommandPtr ->ActiveConnection = pConnectionPtr; pCommandPtr ->CommandType = adCmdText; pCommandPtr ->CommandText = "update test set GBHM = '22' where GBHM = '11'"; pCommandPtr ->Execute (NULL,NULL,adCmdUnknown); #if 0 _RecordsetPtr pRecordsetPtr; pRecordsetPtr.CreateInstance (__uuidof(Recordset)); pRecordsetPtr = pCommandPtr ->Execute (NULL,NULL,adCmdUnknown); int iColCnt = pRecordsetPtr->GetFields()->GetCount(); int iCnt = 0; _bstr_t bstrCol; iCnt = pRecordsetPtr ->GetRecordCount (); while(!pRecordsetPtr->EndOfFile) { for (int iLoop =0;iLoop <iColCnt;iLoop ++) { vItem.intVal = iLoop; vItemData = pRecordsetPtr->GetFields()->GetItem(vItem)->GetValue(); } pRecordsetPtr ->MoveNext (); iCnt ++; }#endif } catch(...) { long errorcount=pConnectionPtr->GetErrors ()->GetCount (); if (errorcount<1) return ; _bstr_t add; _variant_t var; var.vt = VT_I4; for (short i=0;i<errorcount;i++) { var.intVal = i; add=pConnectionPtr->GetErrors ()->GetItem (var)->GetDescription (); } pConnectionPtr ->GetErrors ()->Clear(); } ::CoUninitialize ();} 不能贴一个可以使用SQL语句的麽?还有我用的是DAO谢谢你勒 那个字段是数字还是文本,如果是数字,不要引号的直接update GDKTable set GBHM = 11 where GBHM = 22 VC绘图 如何读取INI文件 用ATL写的COM组件在VC里怎样使用?! 如何实现点击组合框下拉列表的其中一项把它对应的字符串显示到另一个编辑框中? 如何查看变量占用的内存数?在线等。 帮忙用图像算法处理 弱弱的问!为什么我的程序Debug方式没有错误,而Release版本总出错呢? 怎样改变VC里函数的名字 怎样让 文件打开对话框 可以多选,并且获取所选的文件? callback函数 谁能介绍点有关GIS的书籍给我,最好是电子版的,能发给我更好[email protected] 在只有button句柄的情况下,该如何判断我点击的是哪个button?
#include <windows.h>
#include <comdef.h>void main()
{
::CoInitialize(NULL);
_ConnectionPtr pConnectionPtr;
_CommandPtr pCommandPtr;
try
{
pConnectionPtr.CreateInstance (__uuidof(Connection));
pCommandPtr.CreateInstance (__uuidof(Command));
_bstr_t strConnect = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\杂项\\db1.mdb;"
"User Id=管理员;Password=123;Exclusive=1;";
pConnectionPtr ->Open (strConnect,"","",NULL);
pCommandPtr ->ActiveConnection = pConnectionPtr;
pCommandPtr ->CommandType = adCmdText;
pCommandPtr ->CommandText = "update test set GBHM = '22' where GBHM = '11'";
pCommandPtr ->Execute (NULL,NULL,adCmdUnknown);
#if 0
_RecordsetPtr pRecordsetPtr;
pRecordsetPtr.CreateInstance (__uuidof(Recordset));
pRecordsetPtr = pCommandPtr ->Execute (NULL,NULL,adCmdUnknown);
int iColCnt = pRecordsetPtr->GetFields()->GetCount();
int iCnt = 0;
_bstr_t bstrCol;
iCnt = pRecordsetPtr ->GetRecordCount ();
while(!pRecordsetPtr->EndOfFile)
{
for (int iLoop =0;iLoop <iColCnt;iLoop ++)
{
vItem.intVal = iLoop;
vItemData = pRecordsetPtr->GetFields()->GetItem(vItem)->GetValue();
}
pRecordsetPtr ->MoveNext ();
iCnt ++;
}
#endif
}
catch(...)
{
long errorcount=pConnectionPtr->GetErrors ()->GetCount ();
if (errorcount<1)
return ;
_bstr_t add;
_variant_t var;
var.vt = VT_I4;
for (short i=0;i<errorcount;i++)
{
var.intVal = i;
add=pConnectionPtr->GetErrors ()->GetItem (var)->GetDescription ();
}
pConnectionPtr ->GetErrors ()->Clear();
}
::CoUninitialize ();
}
还有我用的是DAO谢谢你勒
直接update GDKTable set GBHM = 11 where GBHM = 22