# 这一段sql那儿错了呢?

Posted by isabelle on August 04, 1998 at 18:10:16:

我在vb程式中写了下面程式:

Dim env As rdoEnvironment
Dim cn As rdoConnection
Dim rst As rdoResultset
.
'
Dim sSQL As String
sSQL = "select * from ce_mget where mget_yn=null"
Set rst = cn.OpenResultset(Name:=sSQL, Type:=rdOpenStatic, LockType:=rdConcurRowver)
If rst.EOF <> True Then
Call DisplayRecord
Else
MsgBox "找不到领料资料"
End If

问题就出在我资料中的mget_yn皆为null, 可是在执行后却找不到资料,
但如我在MSSQL Server中下sSQL的SQL语法, 则会找出所有mget_yn=null
的资料, 那我的程式到底是那儿错了呢?

Follow Ups:

- Re: 这一段sql那儿错了呢? mass 23:40:19 8/04/98 (1)
  - 真是感谢你! isabelle 09:39:17 8/05/98 (0)