How to set a value for a null value in a function in QTP

[galstar]

Hi,

Please help to resolve the following issue..It's urgent..


I have a function for connectivity to DB.Now for result of some query there is now row in table in DB .so for that while returning value QTP shows error ...
Can i set there any default value so that no error get populate..not in DB i want to set a variable while returning value if no result found...if it can be done then plz give me the idea...


Thanks,
Galstar

[jsknight1969]

Assuming you are using a recordset. You probably need to do this:

Code:

if RS.bof then
'no records
else
'do something
end if

Database queries (recordset) return a BOF (beginning of file) if there are no rows.

Hope that helps.