# Re: 这样的SQL语法对吗?

Posted by Edward on September 29, 1998 at 13:07:52:

In Reply to: 这样的SQL语法对吗? posted by JEFF on September 28, 1998 at 20:43:35:

: Sub Q()
: Dim SQL As String
: Dim d As String
: Set dbs = OpenDatabase("c:\T\vbdb.mdb")
: SQL = "delete * from 交易资料 where 班级 = d"

SQL="delete from 交易资料 where 班级 = d"

: Set qd3 = dbs.CreateQueryDef("P", SQL)
: qd3.Parameters!d = text.text
: qd3.Execute
: dbs.QueryDefs.Delete "P"
: dbs.Close
: End Sub

Follow Ups: