这个怎么理解呢~

cmd2007 发布于 2008-04-23 16:54， 893 次点击

Public Function Checkstr(Str)
        If Isnull(Str) Then
            CheckStr = ""
            Exit Function  x
        End If
        Str = Replace(Str,Chr(0),"")
        CheckStr = Replace(Str,"'","''")
    End Function
这两个要怎么理解才对呢Str = Replace(Str,Chr(0),"")
        CheckStr = Replace(Str,"'","''")谢谢

1 回复

tianyu1232008-04-23 17:24

Str = Replace(Str,Chr(0),"")
Chr(0)的值是0 这句的意思是用空格替换掉字符串中的0
CheckStr = Replace(Str,"'","''")
这句的意思是用两个单引号替换掉字符串中的单引号