ADODataSet1.Connection:=ADOConnection1; ADODataSet1.CommandText:='Select * from viewPersonal where cardNo="123"'; ADODataSet1.Open; run 時會出現'Invalid column name' cardNo 的datatype是varchar 我用的是MS SQL server 而run 在access2000 便沒問題 有人可救我嗎?

Hi tidal,    

    ADODataSet1.CommandText:='Select * from viewPersonal where cardNo=''123''';    or    ADODataSet1.CommandText:='Select * from viewPersonal where cardNo='   Quotedstr('123');

---------------------------------- 小弟才疏學淺，若有謬誤尚請不吝指教 ----------------------------------

------
Fishman

Thank you fishman. 我發現這樣也可: ADODataSet1.CommandText:='Select * from viewPersonal where cardNo='#39'abc123'#39; 也可以