Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to differentiate groups of numbers | Excel Worksheet Functions | |||
How do I differentiate between duplicate ranks? | Excel Worksheet Functions | |||
Differentiate b/w False and 0 with InputBox fn | Excel Programming | |||
Differentiate between cell colours | Excel Programming | |||
Differentiate between "" and Empty in array elements. | Excel Programming |