I'm trying to see if my array is empty, but the syntax 'if ubound(arcustomers,2) > -1 is returning a 'Type mismatch: ubound'. What am I doing wrong?
Won't this just tell him if it is an array? I think he wants to know if the array is empty or not. IsArray will return true even if the array is empty.
Right - I can go to only creating the array if the recordset has something in it and then doing IsArray(), but is that necessary? Is there a preferred method? <BR><BR>Thanks.
Set RS = Conn.Execute(SQLStatement)<BR><BR> If Not RS.EOF Then<BR> RSArray = RS.GetRows()<BR> End If<BR><BR> RS.Close<BR>Set RS = Nothing<BR><BR>If IsArray(RSArray) Then<BR> 'We got something<BR>Else<BR> 'We got no-no-nooky<BR>End If