ADOConnection连接字符串:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\invoices_B.mdb;Persist Security Info=False;Jet OLEDB:Database Password=abced当Sql语句为
Select * From MyTbl Where SrcInt=0 时正常
当Sql语句为
Select * From MyTbl Where SrcChr='''' 时正常
当Sql语句为
Select * From MyTbl Where (SrcChr='''') And (SrcInt=0) 时出错,错误信息:“未知”不知道怎么回事,请大侠们执教!
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\invoices_B.mdb;Persist Security Info=False;Jet OLEDB:Database Password=abced当Sql语句为
Select * From MyTbl Where SrcInt=0 时正常
当Sql语句为
Select * From MyTbl Where SrcChr='''' 时正常
当Sql语句为
Select * From MyTbl Where (SrcChr='''') And (SrcInt=0) 时出错,错误信息:“未知”不知道怎么回事,请大侠们执教!
这样呢
Alter Table [表] Alter [id] Counter Constraint [表_p] Primary Key 在字段 等地方加上 []