关于adodb的 查询

[shenfuhua]

我在处理数据库的数据时，想用汉字查询如a.open "select * form success where name="程序",g_conn,,adcmdtex"
它老是出错。是不是ADODB中的SQL不支持汉字查询
[e-mail]

[forever_chang]

将汉字两边的双引号改为单引号

[pengnick]

name="程序"中的双引号应为单引号，正确写法如下：
a.open "select * form success where name='程序'",g_conn,,adcmdtex

[forever_chang]

汉字完全可以作为查询条件

[yanz]

语句改写如下：

a.open "select * form success where name='程序'",g_conn,,adcmdtex"

若汉字在变量中，如下：
a.open "select * form success where name='" & var & "'",g_conn,,adcmdtex"

[cubel]

汉字完全可以的，还可以用like

[bamboo_leo]

ADODB中的SQL是完全支持汉字查询的，从你贴出的贴子来看，是SQL语句的问题。在VB的SQL语句中如果条件为字符串应该用单引号，不能用双引号。如果非要双引号，应该用Chr(34)来代替。
例如：
sSQL="Select a from a='条件'"
或
sSQL="select a from a=" & chr(34) & "条件" & chr(34)

[shenfuhua]

模块中有Public g_conn As ADODB.Connection
from1中的代码
Public Sub Opendatabase()
Set g_conn = New ADODB.Connection
g_conn.ConnectionString = "DSN=sms"
g_conn.Open
If g_conn.State <> adStateOpen Then
MsgBox "数据库打开失败", vbOKOnly + vbCritical + conAppName
Unload frmMain
End If
End Sub

Private Sub Form_Load()
Opendatabase
Dim a As ADODB.Recordset
Set a = New ADODB.Recordset
a.Open "select * from student where xm='水粉画'", g_conn, adOpenStatic, adLockOptimistic, adCmdText
End Sub
出现以错误Too few parameters. expected 1

[worldtomev]

a.open "select * form success where name='程序'",g_conn,,adcmdtex

[shenfuhua]

我现在还是有错，help help

[worldtomev]

DSN....Really? (OLEDB)
Perhaps DNS

[SenseKey]

看这个 a.open "select * from success where name='" 程序 "'"

[worldtomev]

Dim conn
Set conn = CreateObject("adodb.connection")
conn.Open "dsn=sms"
Dim rs
Set conn = opdb()

Set rs = CreateObject("adodb.recordset")
Set rs = conn.Execute("select * from student where xm='水粉画'")

[SenseKey]

怎么回事显示不对另写一遍了 a.open "select * from success where name=' " 程序 " ' "

[shenfuhua]

还不行

[worldtomev]

不知道你的代码和错误信息怎么判断!

[shenfuhua]

Set rs = conn.Execute("select * from student where xm='水粉画'")
他执行的错误是期待的参数是1
Too few parameters. expected 1

[tony_jian]

rst.Find "用户名='" & textuser.Text & "'"

[seafarer777]

如果是字符串变量：
"SELECT * FROM 表名 where 字段='" & text1 & "'"
如果是字符串常量：
"SELECT * FROM 表名 where 字段='中文'"

[worldtomev]

我这完全没问题!(唯一的上面的代码忘删了'Set conn = opdb()' )
估计你的odbc连接不对!控制面板-管理工具-odbc..

[worldtomev]

不然用我的mdb和project试试(email?)