Private Sub Command_click() Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strdb,cardno As String cardno=text.text
cn.Open "Provider=MSDAORA.1;Password=ic6279admin;User ID=ICADMIN;Data Source=ORAISSUE;Persist Security Info=True"
strdb = "select * from mytable where substr(cardcd,5,12)=cardno" rs.Open strdb, cn, adOpenForwardOnly, adLockReadOnly, adCmdText
Set datagrid.DataSource = rs
rs.Close
cn.Close
End Sub
程序执行到rs.open这句时,报无效的标识符cardno
Dim rs As New ADODB.Recordset
Dim strdb,cardno As String cardno=text.text
cn.Open "Provider=MSDAORA.1;Password=ic6279admin;User ID=ICADMIN;Data Source=ORAISSUE;Persist Security Info=True"
strdb = "select * from mytable where substr(cardcd,5,12)=cardno" rs.Open strdb, cn, adOpenForwardOnly, adLockReadOnly, adCmdText
Set datagrid.DataSource = rs
rs.Close
cn.Close
End Sub
程序执行到rs.open这句时,报无效的标识符cardno
解决方案 »
- 如何进行时间搜索?(Access数据库)
- 求一个类似QQ消息、迅雷消息、360系统消息那样的弹框代码。
- 求温贤发的<visual basic 6数据库编程高手>的光盘源码
- 紧急求助(十万火急)
- 小弟新作,多多支持哈
- 简单问题~~~~帮忙啊~~~~
- 请大家帮我推荐一个,只用普通的数学函数的随机整数生成算法
- 各位救命:MSDN中的一段内容
- 我用DataGrid把查询结果显示出来,但我并不想当在DataGrid上每作一修改时就立刻保存到数据库,而是希望能用程序来控制成批的修改.请问DataGrid能实现吗?还是用何种其它方法实现?
- 请问一个进度栏的编写问题。(windows command 6.0)
- 悲啊!软件成为了JAVA的天下了!!!
- 请问哪里有最全的api,自带的连openprocess这样的都没
strdb = "select * from mytable where substr(cardcd,5,12)=" & cardno
debug.print strdb
Dim rs As New ADODB.Recordset
Dim strdb,cardno As String cardno=text.text
cn.Open "Provider=MSDAORA.1;Password=ic6279admin;User ID=ICADMIN;Data Source=ORAISSUE;Persist Security Info=True"
strdb = "select * from mytable where substr(cardcd,5,12)='cardno' " rs.Open strdb, cn, adOpenForwardOnly, adLockReadOnly, adCmdText
Set datagrid.DataSource = rs
rs.Close
cn.Close
End Sub