subject_27997.htm

来自「vc」· HTM 代码 · 共 4 行

<p>
序号：27997 发表者：二进制 发表日期：2003-01-17 09:00:12
<br>主题：用ODBC访问ACCESS库的问题
<br>内容：&nbsp;&nbsp;&nbsp;&nbsp;CDatabase* tmpdb;<BR>&nbsp;&nbsp;&nbsp;&nbsp;Jhuserset* UserSet; //是CRecordset的子类<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;CString&nbsp;&nbsp;sDSN="ODBC;DRIVER=Microsoft Access Driver (*.mdb);DSN='';DBQ=colist.mdb";<BR>&nbsp;&nbsp;&nbsp;&nbsp;tmpdb =new CDatabase;<BR>&nbsp;&nbsp;&nbsp;&nbsp;tmpdb-&gt;Open(NULL,FALSE,FALSE,sDSN,FALSE))<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CString strSQL="select * from user";//(1)问题就在这一行<BR>&nbsp;&nbsp;&nbsp;&nbsp;UserSet=new Jhuserset(tmpdb);<BR>&nbsp;&nbsp;&nbsp;&nbsp;UserSet-&gt;Open(CRecordset::dynaset,strSQL);<BR>以上的代码没问题，但如果把(1)这一行改为：<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CString strSQL="select * from user where [username] = \"sa\"";//select * from user where [username]="sa"<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;就不行，运行到这时提示：参数不足，期待是2（有时说期待是1）？为什么？<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Help me!<BR>2003-1-17 9:34:19