Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

Empty Recordset

Code Example:
...
sq = "SELECT * FROM..."
Set rec = ...
X = rec!SomeThing

Problem:
If no "SomeThing" is found in the database or "SomeThing" is "empty", there will be an error.

Workaround:
On Error Resume next
...
recTest = ""
recTest = rec!SomeThing
If recTest <> "" Then ...

Solution:
What is the "value" of rec!SomeThing, if SomeThing is not found or empty?
0
soeding1
Asked:
soeding1
  • 2
1 Solution
 
deightonCommented:

    sq = "SELECT * FROM..."
    Set rec = ...
    if rec.RecordCount > 0 then

    X = rec!SomeThing

   else
     msgbox "Ooops"
end if

0
 
deightonCommented:
To clarify my answer

If the recordset is empty then you cant' access the field value without error.  You check for this with rec.RecordCount = 0 (indicates empty record set)


0
 
soeding1Author Commented:
deighton,
of course...
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now