R
RB Smissaert
I have the following situation:
An Interbase table with integer and string fields.
Then the following code fragment:
Dim rs As ADODB.Recordset
Dim strQuery As String
Dim arrData
strQuery = "SELECT G.* FROM GPP_INVESTIGATION G WHERE G.ENTRY_ID = " &
lENTRY
Set rs = New ADODB.Recordset
rs.Open Source:=strQuery, _
ActiveConnection:=ADOConn, _
CursorType:=adOpenForwardOnly, _
LockType:=adLockReadOnly, _
Options:=adCmdText
arrData = rs.GetRows
Now I need to know if elements in this array are empty or zero. The problem
is that I can't find a way to
differentiate between these two.
Thanks for any advice on this.
RBS
An Interbase table with integer and string fields.
Then the following code fragment:
Dim rs As ADODB.Recordset
Dim strQuery As String
Dim arrData
strQuery = "SELECT G.* FROM GPP_INVESTIGATION G WHERE G.ENTRY_ID = " &
lENTRY
Set rs = New ADODB.Recordset
rs.Open Source:=strQuery, _
ActiveConnection:=ADOConn, _
CursorType:=adOpenForwardOnly, _
LockType:=adLockReadOnly, _
Options:=adCmdText
arrData = rs.GetRows
Now I need to know if elements in this array are empty or zero. The problem
is that I can't find a way to
differentiate between these two.
Thanks for any advice on this.
RBS