# Answer: SQL Problem

Posted by Spencer Yang on April 09, 1999 at 12:06:26:

In Reply to: 请教您...帅帅阿柳.... posted by 鸡嫂 on April 09, 1999 at 08:35:11:

1)不知是否用sql builder测试过？
2)对于frm2.classList.text部分,
假如 sql句子在 frm1, 与 frm2不同时，不能直接索引。
应该用clipboard或且文字档传递变数 frm2.classlist.text 至 frm1

dim strclassList as string
...
strclasslist = frm2.classList.text
...

3)Where 子句改为
"where stdclass.classcode =" & chr(39) & strclasslist & chr(39)

Follow Ups: