1,216
社区成员
发帖
与我相关
我的任务
分享vb 连sybase数据库时，执行到rs.Open "select * from user_data_mail where send_flag='0'",.......时出错
vb 连sybase数据库时，执行到rs.Open "select * from user_data_mail where send_flag='0'",.......时出错
...全文
请发表友善的回复…
发表回复
wumy_ld 2004-04-11
- 打赏
- 举报
试试
rs.Open "select * from user_data_mail where send_flag=0", conn, adOpenDynamic, adLockOptimistic
send_flag的数据类型是什么？
rs.Open "select * from user_data_mail where send_flag=0", conn, adOpenDynamic, adLockOptimistic
send_flag的数据类型是什么？
northwolves 2004-04-11
- 打赏
- 举报
看看send_flag 类型对否？
ok2004 2004-04-11
- 打赏
- 举报
完整语句：
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.Open "DSN=test_sendmail;UID=sa;PWD=suntek"
rs.Open "select * from user_data_mail where send_flag='0'", conn, adOpenDynamic, adLockOptimistic
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.Open "DSN=test_sendmail;UID=sa;PWD=suntek"
rs.Open "select * from user_data_mail where send_flag='0'", conn, adOpenDynamic, adLockOptimistic
