| dim DBConn Set DBConn = CreateObject("ADODB.Connection")
 DBConn.open "Provider=MSDAORA.Oracle;Data Source=ora9;user id=system;password=oracle"
 dim Rst
 Set Rst=DbConn.executesql("select count(TELNO1) from TB_PROJECT_CRC where TELNO1='12345678'")
 if rst.fields(0)>0 then
 msgbox "找到数据"
 else
 msgbox "没有数据"
 end if
 
 
 
 以上代码用VBS测试出现参数不正确,或不在范围之内,或与其他参数想冲突!
 大虾!为什么?
 |