'查询数据库
Sql="Select Code From [Product]"
Set Rs=Conn.Execute(Sql)
If Rs.Bof And Rs.Eof Then
Sql="Insert Into Product(Code) Values("& GetRnd() &")"
Conn.Execute(Sql)
Else
DataArray=Rs.GetRows(-1)
ReDim SearchArray(Ubound(DataArray,2))
For i=0 To Ubound(SearchArray)
SearchArray(i) = "|"& DataArray(0,i) &"|"
Next
DataArray=Null
Call Insert()
End If
Function GetRnd()
Dim N,upperbound,lowerbound
Randomize() '初始化
lowerbound=7000
upperbound=8000
N=Int((upperbound - lowerbound + 1) * Rnd(Now()) + lowerbound)
GetRnd=N
End Function
Sub Insert()
Dim N
N=GetRnd()
'数据库中存在数据
If Ubound(Filter(SearchArray,"|"& N &"|",True,1))>=0 Then
Call Insert()
Else
Sql="Insert Into Product(Code) Values("& N &")"
Conn.Execute(Sql)
End If
End Sub