# 请问这个 SQL 语法错什么 ?

Posted by kkcheung on September 07, 1998 at 16:38:38:

selstr = "select * from customer where cus_name like '合兴*'"
' selstr = "select * from customer where cus_code like '*" & Text1 & "*'"

Set tempset = FMSDB.OpenRecordset(selstr, dbOpenSnapshot, dbSQLPassThrough)
If tempset.EOF Then
MsgBox "不存在查询之资料 !"
Else
........
确定的是 customer 资料库有很多以 104 开始的 cus_code
但查询结果总是找不到.

Follow Ups:

- Re: 请问这个 SQL 语法错什么 ? 风 07:49:53 9/09/98 (0)