# 有关SQL语法的讯息"参数太少,预期个数C"

Posted by 康宝 on August 12, 1999 at 03:49:48:

请问一下!!
在SQL的语法中
我打入下面的叙述
dim source as string
source=Data1.RecordSource
sql= " SELECT * FROM " & RTrim(source) & " where [栏位1] like 栏位1的资料 and [栏位2]= 栏位2的资料"
Data1.RecordSource = sql
data1.refresh
执行时会告诉我说,"参数太少,预期个数C"
但是我用
sql = "SELECT * FROM " & RTrim(source) & " where [栏位1] like 栏位1的资料"
却动作得很正常
是AND用得不对吗?
谢谢!!

Follow Ups:

- Re: 有关SQL语法的讯息"参数太少,预期个数C" HDM 08:21:17 8/12/99 (1)
  - Re: 有关SQL语法的讯息"参数太少,预期个数C" Fai 12:26:10 8/12/99 (0)