(("select max(cast(carbrand_Id as int)) from car_db") 你这话又不会对数据库进行查询当然有错,它还是select max(cast(carbrand_Id as int)) from car_db,怎么可以+1呢,类型不符
dim cn as new adodb.connection dim rs as new adodb.recordset cn.open "Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=fasterweb;Initial Catalog=dataCar;Data Source=jiangh" rs.CursorLocation = adUseClient rs.CursorType = adOpenStatic rs.open "select max(cast(carbrand_Id as int))+1 as max_id from car_db",cn debug.print rs("max_id").value ... rs.close set rs=nothing cn.close set cn=nothing
dim cn as new adodb.connection dim rs as new adodb.recordsetcn.open "Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=fasterweb;Initial Catalog=dataCar;Data Source=jiangh"rs.CursorLocation = adUseClient rs.CursorType = adOpenStatic rs.open "select max(cast(carbrand_Id as int))+1 as max_id from car_db",cn debug.print rs("max_id").value...rs.close set rs=nothingcn.close set cn=nothing
dim rs as new adodb.recordset
cn.open "Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=fasterweb;Initial Catalog=dataCar;Data Source=jiangh"
rs.CursorLocation = adUseClient
rs.CursorType = adOpenStatic
rs.open "select max(cast(carbrand_Id as int))+1 as max_id from car_db",cn
debug.print rs("max_id").value
...
rs.close
set rs=nothing
cn.close
set cn=nothing
dim rs as new adodb.recordsetcn.open "Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=fasterweb;Initial Catalog=dataCar;Data Source=jiangh"rs.CursorLocation = adUseClient
rs.CursorType = adOpenStatic
rs.open "select max(cast(carbrand_Id as int))+1 as max_id from car_db",cn
debug.print rs("max_id").value...rs.close
set rs=nothingcn.close
set cn=nothing