如何用SQL语句删除指定的记录?

ouxingwang

我编写的代码如下:

dim zh as string

'zh 是帐号

Dim db As ADODB.Connection, rs As Recordset

Set db = New ADODB.Connection

Set rs = New ADODB.Recordset

rs.ActiveConnection = CurrentProject.Connection

rs.Open "分户帐", , adOpenKeyset, adLockOptimistic, adCmdTable

rs.movefirst

zh=rs!帐号

如何用SQL语句删除赋给变量"zh"的记录.我的语句为

DoCmd.RunSQL "delete from  帐号表  where 帐号=zh", -1

但不行,请各位高手指点为盼!

zhengjialon

如果帐号是文本型就用oCmd.RunSQL "delete from  帐号表  where 帐号='" & zh & "';"

是数值型用oCmd.RunSQL "delete from  帐号表  where 帐号=" & zh & ";"

ouxingwang

非常感谢总版主的指点!