一个vb中关于sql的简单问题
Dim gwfeed As Workspace
Dim dbfeed As Database
Dim rstfeed As Recordset
Dim Ren,dated as String
Ren = Text1.text
dated = Text2.text
Datfeed.DatabaseName = "配方表.mdb"
Datfeed.RecordSource = "配方表_兔(index)"
Set gwfeed = CreateWorkspace("", "admin", "")
Set dbfeed = gwfeed.OpenDatabase(Datfeed.DatabaseName, False, False, vbNullString)
category = CStr(Datfeedtemp.RecordSource)
Set rstfeed = dbfeed.OpenRecordset("SELECT * FROM " _
& category & " WHERE 制作人= " & Ren & " AND 配方日期= " & Dated)
为什么提示from语句有错?Datfeed是Data控件,我想根据text1和text2中的内容找到相对应的记录,“制作人”和“配方日期”字段在表中都是文本类型,还有sql语句在vb中是不是表名不可以用中文,请指点,最好能给出一些sql在vb中的范例