1、sqlstr = "select distinct(部门) from result where not isnull(部门)"
rs2.Open sqlstr, Cnn, 1, 1 2、sqlstr = "select 项目列表 from passel where 开始日期 between #" & DTPicker1.value & "# and #" & DTPicker2.value & "#"
rs2.Open sqlstr, Cnn, 1, 1
在vb+access中正常,而在vb+sqlserver中错误,1提示isnull要两个参数,2提示#附近有错误,应怎样写?
rs2.Open sqlstr, Cnn, 1, 1 2、sqlstr = "select 项目列表 from passel where 开始日期 between #" & DTPicker1.value & "# and #" & DTPicker2.value & "#"
rs2.Open sqlstr, Cnn, 1, 1
在vb+access中正常,而在vb+sqlserver中错误,1提示isnull要两个参数,2提示#附近有错误,应怎样写?
rs2.Open sqlstr, Cnn, 1, 1
sqlstr = "select distinct(部门) from result where 部门 is not null"
rs2.Open sqlstr, Cnn, 1, 1 2.2、sqlstr = "select 项目列表 from passel where 开始日期 between "#" & DTPicker1.value & "# and #" & DTPicker2.value & "#"
rs2.Open sqlstr, Cnn, 1, 1